DB SQL 공부

# 건물, 층 , 호실 /  검색 LIKE 사용

SELECT 

A.BULD_PK ,

A.FLT_NM,

A.RM,

B.FLOOR_PK, 

B.FLOOR_NM,

B.RM,

C.HOSIL_PK ,

C.RM

FROM flt_buld A , flt_floor B , flt_hosil C

WHERE A.BULD_PK = B.BULD_PK AND C.FLOOR_PK = B.FLOOR_PK AND A.FLT_NM LIKE '%빌딩%';

# 건물, 층 , 호실 /  검색 0 , 1 , 2

SELECT 

A.BULD_PK ,

A.FLT_NM,

A.RM,

B.FLOOR_PK, 

B.FLOOR_NM,

B.RM,

C.HOSIL_PK ,

C.RM

FROM flt_buld A , flt_floor B , flt_hosil C

WHERE A.BULD_PK = B.BULD_PK AND C.FLOOR_PK = B.FLOOR_PK 

AND A.RM IN ('0','1','2');

# 건물 층 호실 PK 조회

SELECT 

A.BULD_PK ,

B.FLOOR_PK,

C.HOSIL_PK

FROM flt_buld A , flt_floor B , flt_hosil C

WHERE A.BULD_PK = B.BULD_PK AND C.FLOOR_PK = B.FLOOR_PK;

# 특정 컬럼 값 제외 시킬떄 : NOT IN 사용

SELECT *  FROM COM_MENU 

WHERE SORT_ORDER IN(1,2,99)

ORDER BY SORT_ORDER 

SELECT CD_DOMAIN , SORT_ORDER 

FROM COM_CD

WHERE  CD_DOMAIN NOT IN ('COM001', 'COM002' , 'COM003', 'COM004', 'COM005', 'COM006', 'COM007' , 'COM008' , 'COM009' , 'COM0010' , 'COM011' , 'COM012' , 'COM013' , 'COM014')

ORDER BY SORT_ORDER DESC  / 내림차순

# CD_DOMAIN = COM 검색 항목 제외 후 조회

SELECT * FROM COM_CD

WHERE CD_DOMAIN NOT LIKE 'COM%' 

ORDER BY CD_DOMAIN ASC , SORT_ORDER DESC