WITH M_ABC AS (
SELECT A,B
,ROW_NUMBER() OVER (ORDER BY A ASC) AS ROWNO
FROM M_TABLE
WHERE
A = '20')
SELECT A,B
FROM M_ABC
WHERE 1 <= ROWNO And ROWNO <= 5;
WITH M_ABC AS (
SELECT A,B
,ROW_NUMBER() OVER (ORDER BY A ASC) AS ROWNO
FROM M_TABLE
WHERE
A = '20')
SELECT A,B
FROM M_ABC
WHERE 1 <= ROWNO And ROWNO <= 5;