今天无意当中发现,oracle 当中where条件可以这样去写
select * from aa
where (aa.x,aa.y) not in (('1','S'),('2','Z'))
或者
select employee_id, last_name from employees
where (employee_id, level) not in (select employee_id, 2 from employees)
今天无意当中发现,oracle 当中where条件可以这样去写
select * from aa
where (aa.x,aa.y) not in (('1','S'),('2','Z'))
或者
select employee_id, last_name from employees
where (employee_id, level) not in (select employee_id, 2 from employees)