Oracle Database 12c で追加された FETCH FIRST n ROWS構文を使うと、 Top n や 同ソートキー値のレコードを抽出できるんやで彡(ﾟ)(ﾟ)サンプルは以下のデータ SELECT MIN(C1) AS C1_MIN , MAX(C1) AS C1_MAX , COUNT(C1) AS C1_CNT , COUNT(DISTINCT C1) AS …

これでワイもプレミアムや！彡(ﾟ)(ﾟ) ALTER SESSION SET NLS_DATE_FORMAT = 'YYYY/MM/DD'; SELECT TRUNC(NEXT_DAY(SYSDATE+LEVEL, 'friday'), 'MM') AS TUKI , MAX(TRUNC(NEXT_DAY(SYSDATE+LEVEL, 'friday'), 'DD')) AS PREMIUM FROM DUAL CONNECT BY LEVEL …