TOP 1 대체 SQL
데이터베이스/SQL 2018. 11. 11. 23:06
TOP 1 대체 SQL
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | /* TEST DATA */ WITH TEST AS ( SELECT '201801' AS YM, '1' AS SEQ UNION ALL SELECT '201802' AS YM, '2' AS SEQ UNION ALL SELECT '201803' AS YM, '3' AS SEQ UNION ALL SELECT '201804' AS YM, '4' AS SEQ UNION ALL SELECT '201802' AS YM, '1' AS SEQ UNION ALL SELECT '201803' AS YM, '2' AS SEQ UNION ALL SELECT '201804' AS YM, '3' AS SEQ UNION ALL SELECT '201805' AS YM, '4' AS SEQ UNION ALL SELECT '201801' AS YM, '1' AS SEQ UNION ALL SELECT '201802' AS YM, '2' AS SEQ UNION ALL SELECT '201803' AS YM, '3' AS SEQ UNION ALL SELECT '201804' AS YM, '4' AS SEQ UNION ALL SELECT '201805' AS YM, '1' AS SEQ UNION ALL SELECT '201806' AS YM, '2' AS SEQ ) /* SQL */ SELECT MAX(YM) KEEP (DENSE_RANK FIRST ORDER BY YM DESC) AS MAX_YM , MAX(SEQ) KEEP (DENSE_RANK FIRST ORDER BY SEQ DESC) AS MAX_SEQ FROM TEST; | cs |
'데이터베이스 > SQL' 카테고리의 다른 글
ROLLUP을 이용한 부서별 상위계정과목 집계 SQL (0) | 2018.11.10 |
---|