데이터베이스/Oracle
Oracle In 과 Not In
왕왕왕왕
2015. 11. 6. 16:32
SELECT column_name(s)
FROM table_name
WHERE column_name IN (value1,value2,...);
FROM table_name
WHERE column_name IN (value1,value2,...);
SELECT column_name(s)
FROM table_name
WHERE column_name NOT IN (value1,value2,...);
in은 지정한 value값만 검색하는거고
not in은 지정한 value값을 빼고 검색하는것