Is there any Property In MS SQL Server Like Rownum in Oracle

[Ashutosh]

Hi All....

I have to write one query where i have to display the ID as 1,2 3, 4 in
oracle we used to ROWNUM to display ....in MS SQL server is there any
property to show???

i have to display like

ID ProgramCount
1 4
2 6
3 5
4 1
5 2

Ashutosh

 

[Shankar Reddy]

I don't think there is a direct way but you can get the same results with the following Select statement.

use pubs
GO
Select IDENTITY(int, 1,1) id, * INTO #Temp from authors
Select * from #Temp


try this.

Thanks,
Shankar Reddy

 

[msgrockclimber]

Row_Number() should do the trick...

Select
  SalesOrderID, CustomerID, [COLOR="Red"][B]Row_Number() Over (Order By SalesOrderID) as RunningCount[/B][/COLOR]
From
  Sales.SalesOrderHeader
Where
  SalesOrderID > 10000
Order By
  SalesOrderID