分页查找

sql server : select top 10 * from table1 where id not in(select top 0 id from table1 )

mysql　　: select * from table1 LIMIT 0,6