Link to home
Start Free TrialLog in
Avatar of Sri10
Sri10

asked on

rowid equivalent in sqlserver 2005

Hi,
Can any one let me know the oracles's rowid, rownum equivalent in sql server 2005?
ASKER CERTIFIED SOLUTION
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Avatar of dportas
dportas

ROW_NUMBER() is the ISO standard function which is available in both SQL Server and Oracle and other DBMSs.