能这样用么?
语法是这样的哦Intersect(«Set1», «Set2»[, ALL])
你那个这样应该达到目的了:
select name
from student where department= '50'and sex='man'
语法是这样的哦Intersect(«Set1», «Set2»[, ALL])
你那个这样应该达到目的了:
select name
from student where department= '50'and sex='man'
from student where sex='man')
select name from student where department= '50'and sex='man'