1. 예시 자료 정렬
  - 값만 있고 정렬 기준이 없네요?
  - 정렬기준이 있어야만 하는 문제입니다.
2. 예시 자료 패턴
  - 항상 1로 시작헤서 1씩 증가하나요? (1,2,3)
  - 2로 시작한다거나? (2,3,4)
  - 2에서 4로 넘어간다거나 하는 자료는 없나요? (1,2,4)

WITH T AS (
	SELECT 1 cnt FROM DUAL UNION ALL
	SELECT 2 FROM DUAL UNION ALL
	SELECT 3 FROM DUAL UNION ALL
	SELECT 1 FROM DUAL UNION ALL
	SELECT 2 FROM DUAL UNION ALL
	SELECT 1 FROM DUAL UNION ALL
	SELECT 2 FROM DUAL
)
SELECT cnt, no FROM T, (SELECT @temp := 0) T2 ORDER BY @temp := @temp + 1 DESC LIMIT 2

WITH t AS
(SELECT 1 AS cnt FROM dual UNION ALL
SELECT 2 FROM dual UNION ALL
SELECT 3 FROM dual UNION ALL
SELECT 1 FROM dual UNION ALL
SELECT 2 FROM dual UNION ALL
SELECT 1 FROM dual UNION ALL
SELECT 2 FROM dual)


SELECT * 
  FROM  (SELECT ROW_NUMBER() OVER(ORDER BY ROWNUM DESC ) RN
             , T.* 
          FROM T
        ) 
  WHERE RN <= 2 

겨우 했습니다. 감사합니다

WITH t AS
(SELECT 1 AS cnt FROM dual UNION ALL
SELECT 2 FROM dual UNION ALL
SELECT 3 FROM dual UNION ALL
SELECT 1 FROM dual UNION ALL
SELECT 2 FROM dual UNION ALL
SELECT 1 FROM dual UNION ALL
SELECT 2 FROM dual)
SELECT * FROM 
(SELECT ROWNUM rn, cnt FROM t) tt
WHERE tt.rn >=
(SELECT MAX(ee) FROM
(SELECT ROWNUM AS ee, cnt FROM t 
GROUP BY ROWNUM, cnt
HAVING cnt = 1));