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
AshutoshHave look here:
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
No comments:
Post a Comment