개발/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