17,382
社区成员




select s_landedcost,s_styleno,s_seasonyear,s_seasoncode
from t_style
where (s_styleno,s_seasonyear,s_seasoncode) in
('NH199','2005','N'
,'NH199','2005','N' );
--可以这样
select s_landedcost, s_styleno, s_seasonyear, s_seasoncode
from t_style
where (s_styleno, s_seasonyear, s_seasoncode) in
(('NH199', '2005', 'N'),( 'NH199', '2005', 'N'));
select *
from emp
where (job, deptno) in (SELECT JOB, DEPTNO FROM EMP WHERE DEPTNO = 20)
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO FLAG
----- ---------- --------- ----- ----------- --------- --------- ------ ----
7876 ADAMS CLERK 7788 1987-5-23 1100.00 20
7369 SMITH1 CLERK 7912 1980-12-17 800.00 20
7566 JONES MANAGER 7839 1981-4-2 2975.00 20
7902 FORD ANALYST 7566 1981-12-3 3000.00 20
7788 SCOTT ANALYST 7566 1987-4-19 3000.00 20