單表查詢：

常規(guī)查詢：

SELECT 列名 From 表名

去重式查詢： DISTINCT

SELECT DISTINCT Sno FROM SC;

比較式查詢：BETWEEN = <

SELECT Sname FROM Student WHERE Sage<20;
SELECT Sname FROM Student WHERE Sage Between 20 AND 40;
SELECT NAME FROM Student WHERE Sdept='CS' AND age<20;

字符串匹配式查詢：% _

SELECT NAME FROM Student WHERE NAME LIKE '歐陽__'

排序式查詢：ORDER BY

SELECT NAME FROM Student WHERE AGE=22 ORDER BY ID;

統(tǒng)計(jì)式查詢： COUNT(*) ， AVG(ID) ， MAX(ID) ， GROUP BY

SELECT COUNT(*) FROM Student;

SELECT COUNT(DISTANT NAME) FROM Student;

SELECT AVG(ID) FROM Student;

SELECT MAX(ID) FROM Student;

SELECT ID,COUNT(ID) FROM Student GROUP BY ID HAVING COUNT(*)>3;

多表查詢：

連接查詢：SELECT A.B C.D FROM A,C WHERE ....

SELECT STUDENT.*,SC.* FROM STUDENT,SC WHERE STUDENT.Sno=SC.Sno;

嵌套查詢： WHERE...IN(SELECT...)

SELECT NAME FROM STUDENT WHERE Sno IN (SELECT Sno FROM SC WHERE Cno='2')

帶有EXISTS 謂語的BOOL子查詢

SELECT NAME FROM Student WHERE EXISTS (SELECT * FROM SC WHERE Sno=Student.Sno AND Cno='1')

集合查詢：

SELECT * FROM Student WHERE Sdept='CS' UNION SELECT * FROM Student WHERE Sage<=19;