mysql - How to implement LIMIT with Microsoft SQL Server? -

i have query mysql :

select * table1 limit 10,20 

how can microsoft sql ?

starting sql server 2005, can this...

use adventureworks; go orderedorders (     select salesorderid, orderdate,     row_number() on (order orderdate) 'rownumber'     sales.salesorderheader  )  select *  orderedorders  rownumber between 10 , 20; 

or 2000 , below versions...

select top 10 * (select top 20 table order id) order id desc