Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-14 : 01:19:07
|
jdado writes "Hi,
Hope you can answer this one.
I want to return the row number based on the
order field I choose.
ex. table "items" sorted by field "title" and
primary field "itemnum" = 123453
itemnum title rownumber
123451 title1 1
123452 title2 2
123453 title3 3
So if I want to know:
What rownumber does itemnum=123453 would it be when
it is sorted by title.. The answer would be 3
What could be the SQL query for this?
Thanks.." |
|
|
|
|
|
record counter