개발/DB
MSSQL - MySQL의 limit
dnsdud
2013. 5. 10. 16:56
SELECT * FROM MyTable WHERE idx LIMIT 5,20
=>
SELECT TOP 20 * FROM MyTable WHERE idx NOT IN(SELECT TOP 5 idx FROM MyTable)
출처 : http://blog.naver.com/PostView.nhn?blogId=nhsang&logNo=40127533058