select row_number() OVER (ORDER BY key) as RunningN,* from TBLName
select rank() OVER (ORDER BY key) as RunningN,* from TBLName
Sunday, February 1, 2009
Add running number to row
Subscribe to:
Comments (Atom)
skip to main |
skip to sidebar
asp.net, mssql, mysql, oracle, asp.net 2.0, visaul studio 2005, programming, vb.net, C#.net, vb, C#, database, connection, stored procedure, design, web services
Books for asp.net