搜索１.sql

来自「数据库方面的知识 最基本的建表」· SQL 代码 · 共 20 行

select distinct SNO 
from SPJ 
where JNO='J1';

select distinct SNO 
from SPJ 
where JNO='J1'and PNO='P1';

select distinct SNO 
from SPJ, P
where JNO='J1'and SPJ.PNO=P.PNO and COLOR='红';

select distinct SPJ.JNO 
from J, P,SPJ
where  CITY !='天津'and COLOR !='红'and J.JNO=SPJ.JNO and SPJ.PNO=P.PNO;

select distinct JNO 
from SPJ 
where SNO='S1' 
and PNO=any(select distinct PNO from SPJ where SNO='S1');