ROWNUM in SQL-SERVER

<i><b>Originally posted by : Ramesh (ramesh_bhanu@yahoo.com)</b></i><br /><br /><br /> I am trying to select a row number from SQL Server 2000, and do not know SQL<br />select for this. I know Oracle has rownum. What is the SQL version of this?<br /><br />Thanks

<i><b>Originally posted by : Erick Vils (erick@websoftware.com.br)</b></i><br />In SQL Server or Access databases the where clause rownum <= 50 can be replaced by:<br /><br />select TOP 50 * from table<br /><br /><br />http://www.websoftware.com.br<br /><br />------------<br />Ramesh at 6/4/2001 4:55:29 AM<br /><br /><br /><br /> I am trying to select a row number from SQL Server 2000, and do not know SQL<br />select for this. I know Oracle has rownum. What is the SQL version of this?<br /><br />Thanks

<i><b>Originally posted by : syed (syedkattuva@yahoo.com)</b></i><br /><br />I want to know, how to use ROWNUM for the following case in SQL Server.<br /><br />For Exam:<br /><br />Table : TEST<br /><br />TESTID TESTNAME<br />------------------------------------------------<br />100 THOMAS ANTONY<br />101 MARK SMITH<br />100 THOMAS ANTONY<br /><br />I have duplicate rows in above case. So i want to delete one duplicate record.<br /><br />In Oracle i will use the following query,<br /><br />SQL> DELETE FROM TEST WHERE TESTID=100 WHERE ROWNUM<=1<br /><br />How to apply the same query in SQL Server..<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />------------<br />Erick Vils at 6/5/2001 7:55:45 AM<br /><br />In SQL Server or Access databases the where clause rownum <= 50 can be replaced by:<br /><br />select TOP 50 * from table<br /><br /><br />http://www.websoftware.com.br<br /><br />------------<br />Ramesh at 6/4/2001 4:55:29 AM<br /><br /><br /><br /> I am trying to select a row number from SQL Server 2000, and do not know SQL<br />select for this. I know Oracle has rownum. What is the SQL version of this?<br /><br />Thanks