01
We can find multiple values using IN
and placing the values we want inside () parenthesis seperated by , commas
SELECT *
FROM student
WHERE name IN ('Claire','Jack','Mike');
IN
We can find multiple values using IN
and placing the values we want inside () parenthesis seperated by , commas
SELECT *
FROM student
WHERE name IN ('Claire','Jack','Mike');
**Remember you can combine all the techniques seen in this section and the previous
SELECT *
FROM student
WHERE major IN('Biology','Sociology') AND name <> 'Jack'
This example finds any name not 'John' and the student id is greate than 3 (just confusing for practice)
