Link to home
Start Free TrialLog in
Avatar of aryaboy
aryaboy

asked on

MS SQL ROW Number

In Oracle you can select row with clause <where rownumber = 2334>. How I can do the same in MS SQL? Do you know system veriables or function that return referenced ROW number?
Avatar of aryaboy
aryaboy

ASKER

Edited text of question
There is no ROWID functino in MSSQL, however you can try using IDENTITY column property to emulate such behavior.
Avatar of aryaboy

ASKER

I cannot find the answer!
Any comments ? Why do you reject correct answer?
ASKER CERTIFIED SOLUTION
Avatar of gmoriak
gmoriak

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
[from thresher_shark]

This question appears to have become corrupted.

aryaboy - You may wish to post a new copy of this question.
[from thresher_shark]

This question appears to have become corrupted.

aryaboy - You may wish to post a new copy of this question.
No comments.
This question's now fixed.