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 - 2007-03-20 : 09:06:09
|
| helen writes "I have a sql table: NAME AGE Anna 10 Susan 5 Dina 12 Please help me to come up with a QUERY STATEMENT with this result: SEQNO NAME AGE 1 Anna 10 2 Susan 5 3 Dina 12 " |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-20 : 09:08:35
|
[code]select SEQNO = (ROW_NUMBER() OVER (ORDER BY AGE)), NAME, AGEfrom sqltable[/code]
KH |
 |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
|
|
|
generate sequence no in one column