SQL语言基础

分组查询
SELECT * FROM books;
SELECT sum(price*qty) FROM books;
SELECT sum(price*qty) FROM books GROUP BY pub;  按pub排序
SELECT pub,sum(price*qty) FROM books WHERE price>30 GROUP BY pub;
SELECT pub,sum(price*qty) FROM books GROUP BY pub HAVING sum(price)>50;  聚集函数不能跟在where后面，如要使用聚集函数则应跟在having后面
SLECT a1,count(a1) FROM aa GROUP BY a1 HAVING COUNT(a1)>1;查询a1字段有多少重复行
模糊查询
SELECT * FROM aa;
SELECT * FROM WHERE a1 LIKE ‘a_’; 任意以a开头，单个字符结尾的
SELECT * FROM WHERE a1 LIKE ‘a%’; 任意以a开头，任意多个字符结尾的
SELECT * FROM WHERE a1 LIKE ‘_a’; 任意单个字符开头，a结尾的
SELECT * FROM WHERE a1 LIKE ‘%a’; 任意多个字符开头，a结尾的
SELECT * FROM WHERE a1 LIKE ‘%a%’;只要包含a不管在开头结尾都查询出来
SELECT * FROM e WHERE ename LIKE ‘张%’；查询员工表姓张的