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