首页 > 技术文章 > 第几行记录

kakaisgood 2019-08-30 20:13 原文

SELECT * FROM (
SELECT ACCT_NUM, ROW_NUMBER()
   OVER (PARTITION BY LC ORDER BY ACCT_NUM) AS emp_id
   FROM ACCOUNT WHERE LC='720220' ) WHERE  emp_id>'41404' and  emp_id<'41500';

 

推荐阅读