JanaGanaMana
Register
Login
Musings
Public · Protected · Private
All Blogs
Any way to get serial number in SQL query?
Type:
Public
|
Created:
2013-05-31
|
Frozen:
Yes
« Previous Public Blog
Next Public Blog »
Comments
select id,name from student
I need select SerialNumber, id, name from student
2013-05-31 16:09
select
ROW_NUMBER
()
Over
(
Order
by
Id
)
As
[S.N.]
,
Id,name
from Students
2013-05-31 16:36
This blog is frozen. No new comments or edits allowed.
select id,name from student
I need select SerialNumber, id, name from student
select
ROW_NUMBER() Over (Order by Id) As [S.N.], Id,name from Students