How can I number rows/records in a record set?
Meaning, I have :
select id,name,address,phone#
from blah,blah,blah
where blah,blah,blah
My results could look like this:
ID Name Address Phone#
1 Ted 123anytown 1231231234
1 Ted 123anytown 1231231245
2 ED 789mystreet 5675675678
What I need is something I can add in the sql that will give me an indication of the # of rows containing that id number, like:
Row# ID Name Address Phone#
1 1 Ted 123anytown 1231231234
2 1 Ted 123anytown 1231231245
1 2 ED 789mystreet 5675675678
Any thought's would be appreciated. Thanks.
Meaning, I have :
select id,name,address,phone#
from blah,blah,blah
where blah,blah,blah
My results could look like this:
ID Name Address Phone#
1 Ted 123anytown 1231231234
1 Ted 123anytown 1231231245
2 ED 789mystreet 5675675678
What I need is something I can add in the sql that will give me an indication of the # of rows containing that id number, like:
Row# ID Name Address Phone#
1 1 Ted 123anytown 1231231234
2 1 Ted 123anytown 1231231245
1 2 ED 789mystreet 5675675678
Any thought's would be appreciated. Thanks.