-- [SQL-1-3-2-1-a]
SELECT t1.mbr_id ,t1.ord_no
,(SELECT s1.nick_nm FROM startdbpg.ms_mbr s1 where s1.mbr_id = t1.mbr_id) nick_nm
,(SELECT s2.mbr_gd FROM startdbpg.ms_mbr s2 where s2.mbr_id = t1.mbr_id) mbr_gd
,(SELECT s3.mobl_no FROM startdbpg.ms_mbr s3 where s3.mbr_id = t1.mbr_id) mobl_no
FROM startdbpg.tr_ord t1
ORDER BY t1.ord_no DESC
LIMIT 1000;
SQL
복사
-- [SQL-1-3-2-2-a]
SELECT COUNT(*) ord_cnt
FROM startdbpg.tr_ord t1
WHERE TO_CHAR(t1.ord_dtm,'YYYYMMDD') = '20240101';
SQL
복사
-- [SQL-1-3-2-3-a]
SELECT COUNT(*)
INTO v_cnt
FROM startdbpg.tr_ord t1
WHERE t1.ord_dtm >= '2024-01-01'::date
AND t1.ord_dtm < '2024-01-02'::date;
IF v_cnt > 0 THEN …
SQL
복사