160;1340;측테1060;블 데1060;터에서 우측테1060;블처/100; 출/141;Ȣ16;고1088;합니다(2번1704; 행만 없Ǻ12;1276;다 보시면.121;니다)
Select MAX(Coldate) as ColDate, ColName From Table Group by ColName1004;/196;Ȣ16;면
여기까1648;lj16; 출/141;해냈습니다.
1060;러1200;러해도 뒤엣 3, 4번1704; 컬/100;1012; 출/141;Ȣ16;기 Ǻ12;/140;워 1312;Ǻ16;1012; 구합니다 12640;12640;
WITH TEMP_TABLE AS
(SELECT '2022-11-29' COLDATE, '»óÇ°A' COLNAME, 14 COLWIDTH, 9 COLHEIGHT FROM DUAL UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°A' COLNAME, 15 COLWIDTH, 9 COLHEIGHT FROM DUAL UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°B' COLNAME, 52 COLWIDTH, 52 COLHEIGHT FROM DUAL UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°C' COLNAME, 27 COLWIDTH, 27 COLHEIGHT FROM DUAL UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°D' COLNAME, 15 COLWIDTH, 9 COLHEIGHT FROM DUAL UNION ALL
SELECT '2022-11-2E' COLDATE, '»óÇ°E' COLNAME, 14 COLWIDTH, 9 COLHEIGHT FROM DUAL)
SELECT A.COLDATE, A.COLNAME, A.COLWIDTH, A.COLHEIGHT
FROM TEMP_TABLE A
INNER JOIN (
SELECT COLNAME, MAX(COLDATE) COLDATE
FROM TEMP_TABLE
GROUP BY COLNAME
) B ON A.COLDATE = B.COLDATE AND A.COLNAME = B.COLNAME;
DB Á¾·ù, ¹öÀü¿¡ µû¶ó ´Ù¸¦ ¼ö ÀÖÀ¸´Ï
Äõ¸® Áú¹®Àº »ç¿ëÇÏ´Â DB Á¾·ù ¹öÀüÀ» ±âº»À¸·Î Ç¥±âÇØ¾ß Á¤È®ÇÑ ´äº¯À» ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
SELECT ColDate, ColName, ColWidth, ColHeight
FROM (
SELECT rank() over (partition by ColName order by ColDate DESC) rk
,*
FROM Å×À̺í¸í
) lst
WHERE rk=1
µ¥ÀÌÅÍ°¡ ¸¹°í ColDate, ColName ÀÌ PK(¶Ç´Â À妽º°¡ ¼³Á¤µÈ)ÀÎ Å×À̺íÀÇ °æ¿ì À§¿¡ Àϱ¹´ÔÀÌ ¼³¸íÇϽŠ¹æ¹ýÀ¸·Î Çؾß
¼Óµµ°¡ ºü¸§´Ï´Ù.
WITH TEMP_TABLE AS (
SELECT '2022-11-29' COLDATE, '»óÇ°A' COLNAME, 14 COLWIDTH, 9 COLHEIGHT UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°A' COLNAME, 15 COLWIDTH, 9 COLHEIGHT UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°B' COLNAME, 52 COLWIDTH, 52 COLHEIGHT UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°C' COLNAME, 27 COLWIDTH, 27 COLHEIGHT UNION ALL
SELECT '2022-11-28' COLDATE, '»óÇ°D' COLNAME, 15 COLWIDTH, 9 COLHEIGHT UNION ALL
SELECT '2022-11-27' COLDATE, '»óÇ°E' COLNAME, 14 COLWIDTH, 9 COLHEIGHT
)
SELECT ColDate, ColName, ColWidth, ColHeight
FROM (
SELECT ( select count(*)
from TEMP_TABLE counter
where counter.ColName = TEMP_TABLE.ColName -- Partition
and counter.ColDate >= TEMP_TABLE.ColDate -- Order
) as rk
,*
FROM TEMP_TABLE
) lst
WHERE rk=1