Search

6-3-3. LIMIT MIN/MAX

-- [SQL-6-3-3-a] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT MAX(t1.ord_no) last_ord_no FROM startdbpg.tr_ord_big t1;
SQL
복사
-- [SQL-6-3-3-b] EXPLAIN (ANALYZE,BUFFERS,COSTS OFF) SELECT t1.ord_no last_ord_no FROM startdbpg.tr_ord_big t1 ORDER BY t1.ord_no DESC LIMIT 1;
SQL
복사