3

SQL学习--嵌套查询

 2 years ago
source link: https://fann.im/blog/2008/04/14/sql-study-select-3/
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

SQL学习--嵌套查询

Apr 14, 2008

IN谓词子查询：

select Sno,Sname,Sdept from Student
where sdept IN
 (select Sdept from Student where Sname ='WANG');

select Sno,Sname from Student where Sno IN
 (select Sno from SC where Cno IN
  (select Cno from Course where Cname ='shujuku4'))

ANY(SOME)或ALL谓词子查询：

select Sname,Sage from Student
where Sage < ANY ( select Sage from Student where Sdept ='CS')
AND Sdept <> 'CS';

EXISTS谓词子查询：

select Sname from Student where EXISTS
    (select * from SC where Sno =Student.Sno AND Cno='1');

select DISTINCT Sno from SC SCX where NOT EXISTS
  (select * from SC SCY where SCY.Sno ='1002' AND NOT EXISTS
    (select * from SC SCZ where SCZ.Sno = SCX.Sno AND SCZ.Cno = SCY.Cno));

Was this page helpful?


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK