-- [SQL-6-3-4-a]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT MAX(t1.ord_no+1) new_ord_no
FROM startdbpg.tr_ord_big t1;
SQL
복사
-- [SQL-6-3-4-b]
EXPLAIN (ANALYZE,BUFFERS,COSTS OFF)
SELECT MAX(t1.ord_no) + 1 new_ord_no
FROM startdbpg.tr_ord_big t1;
SQL
복사
-- [SQL-6-3-4-c]
SELECT MAX(TO_CHAR(t1.ord_dtm,'YYYYMMDD')) last_ord_ymd
FROM startdbpg.tr_ord_big t1;
SQL
복사
-- [SQL-6-3-4-d]
SELECT TO_CHAR(MAX(t1.ord_dtm),'YYYYMMDD') last_ord_ymd
FROM startdbpg.tr_ord_big t1;
SQL
복사
-- [SQL-6-3-4-e]
-- 1. SUM 집계함수 후에 COALESCE 처리
SELECT COALESCE(SUM(t1.ord_amt),0) ord_amt_sum
FROM startdbpg.tr_ord_big t1;
-- 2. SUM 집계함수 전에 COALESCE 처리
SELECT SUM(COALESCE(t1.ord_amt,0)) ord_amt_sum
FROM startdbpg.tr_ord_big t1;
SQL
복사