Hi,

I need to create a query that gets the 2 largest number from a table. In orcale the script would have been:

select * from (select number,name from xx order by n desc) where rownum<3.

How do I use rownum in SQL Server (which is not SQL Server 2005)?

Thanks

You don't appear to need rownum, just select the TOP 2 rows and order by number descending. Look in Books On Line for the TOP keyword for examples.

--

Joe (Microsoft MVP - XML)

Like this... SELECT TOP 2 Number, Name FROM xx Order By N DESC

Joe is correct, though... there's more info in Books Online... make the time to look it up so that you understand how it works (and doesn't). TOP is not programmable in 2k... it is in 2k5.

--Jeff Moden