add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
9 rows affected
CUSTOMER_NAME
JANE01
JANE02
JANE03
CUSTOMER_NAME
JANE03
JANE03
JANE03
JANE02
JANE02
JANE02
PLAN_TABLE_OUTPUT
EXPLAINED SQL STATEMENT:
------------------------
SELECT /**/ DISTINCT CUSTOMER_NAME FROM SALES ORDER BY LAST_SALE_DATE
desc FETCH FIRST 6 ROWS ONLY
Plan hash value: 704191591
------------------------------------------
| Id | Operation | Name |
------------------------------------------
| 0 | SELECT STATEMENT | |
| 1 | VIEW | |
| 2 | WINDOW SORT PUSHED RANK| |
| 3 | VIEW | |
| 4 | HASH UNIQUE | |
| 5 | TABLE ACCESS FULL | SALES |
------------------------------------------
Column Projection Information (identified by operation id):
-----------------------------------------------------------
   1 - (rowset=256) "from$_subquery$_003"."CUSTOMER_NAME"[VARCHAR2,16],
       "from$_subquery$_003"."rowlimit_$$_rownumber"[NUMBER,22]
   2 - (#keys=1; rowset=256) "from$_subquery$_002"."rowlimit_$_0"[DATE,7
       ], "from$_subquery$_002"."CUSTOMER_NAME"[VARCHAR2,16], ROW_NUMBER()
       OVER ( ORDER BY INTERNAL_FUNCTION("from$_subquery$_002"."rowlimit_$_0")
       DESC )[22]
   3 - (rowset=256) "from$_subquery$_002"."CUSTOMER_NAME"[VARCHAR2,16],
       "from$_subquery$_002"."rowlimit_$_0"[DATE,7]
   4 - (#keys=2; rowset=256) "CUSTOMER_NAME"[VARCHAR2,16],
       "LAST_SALE_DATE"[DATE,7]
   5 - (rowset=256) "CUSTOMER_NAME"[VARCHAR2,16],
       "LAST_SALE_DATE"[DATE,7]
1 rows affected

dbms_output:
SELECT "A1"."CUSTOMER_NAME" "CUSTOMER_NAME" FROM  (SELECT "A2"."CUSTOMER_NAME" "CUSTOMER_NAME","A2"."rowlimit_$_0" "rowlimit_$_0",ROW_NUMBER() OVER ( ORDER BY "A2"."rowlimit_$_0" DESC ) "rowlimit_$$_rownumber" FROM  (SELECT DISTINCT "A3"."CUSTOMER_NAME" "CUSTOMER_NAME","A3"."LAST_SALE_DATE" "rowlimit_$_0" FROM "FIDDLE_JBHAUMXYAIEFDNWRHDRJ"."SALES" "A3") "A2") "A1" WHERE "A1"."rowlimit_$$_rownumber"<=6 ORDER BY "A1"."rowlimit_$_0" DESC