한정 술어

; Sub Query의 결과를 비교 조건으로 사용하고 싶을 때 이용

1) ALL

SELECT menu FROM tbl_menu1 WHERE price > ALL
             (SELECT price FROM tbl_menu1 WHERE menu LIKE '%닭%');


2) EXISTS, NOT EXISTS

SELECT * FROM tbl_menber WHERE EXISTS
               (SELECT name FROM tbl_member WHERE no = 5);

SELECT * FROM tbl_menber WHERE NOT EXISTS
               (SELECT name FROM tbl_member WHERE no = 5);

3) ANY

SELECT name, price FROM tbl_stock WHERE price = ANY (SELECT price FROM tbl_stock WHERE country LIKE 'america');