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';
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';