sudagn
Tuesday, May 6, 2008
Selecting the row based on the row number in sql server 2005
select * from (SELECT ROW_NUMBER() OVER (ORDER BY pkuserid ASC) AS ROWID, * FROM users) as t where t.rowid=3
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment