IN指令

• 看看有沒有存在於in 後面的query查出來的資料，not in 就是 in 的相反

select name from main where sex='男性' and name

in (

select name from main where name like '李%'

);

select cid,model,price from car where cid in

(

select cid from sale where num>5

);