atib0539
幼苗
共回答了12个问题采纳率:91.7% 举报
1.select * from J where CITY = '上海'
2.select top 1 PNO from P order by WEIGHT (where中不能用聚集函数)
3.select S.SNO from J,S,SPJ where SPJ.SNO=S.SNO and SPJ.JNO=J.JNO and JNO='J1'
4.select S.SNO from P,J,S,SPJ where SPJ.SNO=S.SNO and SPJ.JNO=J.JNO SPJ.PNO=P.PNO and J.JNO='J1' and P.PNO='P1'
5.select J.JNAME from S,J,SPJ where SPJ.SNO=S.SNO and SPJ.JNO=J.JNO and S.SNO='S1'
6.select distinct P.COLOR from P,SPJ,S where SPJ.SNO=S.SNO and SPJ.PNO=P.PNO and S.SNO='S1'
7.select S.SNO from S,J,P,SPJ where SPJ.SNO=S.SNO and SPJ.JNO=J.JNO SPJ.PNO=P.PNO and (J.JNO='J1' or J.JNO='J2')
8.select S.SNO from S,J,P,SPJ where SPJ.SNO=S.SNO and SPJ.JNO=J.JNO SPJ.PNO=P.PNO and J.JNO='J1' and P.COLOR='红色'
应该就是这样啦……
1年前
4