MSSQL에서 limit(mysql의 from, to) 기능 사용방법

mysql

“select * from t_name limit 0, 1000”

MSSQL

“select row_number() as rownum, * from t_name  where rownum BETWEEN 0 and 1000”

mysql

“select * from t_name limit 3, 1000”

MSSQL

“select row_number() as rownum, * from t_name where rownum BETWEEN 3 and 3+1000”

답글 남기기