欢迎大家光临我的博客!
今天首先说一下高级查询下↓
然后再给大家说一下聚合函数。
一、高级查询
(1)--内连接查询(跟表的位置无关)
select u.name,s.grade from score as s inner join users as u on s.uid=u.id
select u.name,s.grade from users as u inner join score as s on s.uid=u.id
(2)--左外连接查询(跟表的位置有关)
select u.name,s.grade from score as s left join users as u on s.uid=u.id
select u.name,s.grade from users as u left join score as s on s.uid=u.id
(3)--右外连接查询(跟表的位置有关)
select u.name,s.grade from score as s right join users as u on s.uid=u.id
select u.name,s.grade from users as u right join score as s on s.uid=u.id
(4)--like模糊查询
select id,name from users where name like '%a%'
(5)--between...and
select id,name from users where id between 1 and 2
select id,name from users where id >=1 and id<=2
(6)--in
select id,name from users where id in(1,2,3)
二、聚合函数
(1)--sum avg
select sum(id) as 总和 from users
select avg(id) as 平均 from users
(2)--max min
select max(id) as 最大,min(id) as 最小 from users
(3)--count
select count(*) as 总人数 from users
select count(password) as 总人数 from users
(4)--分组
select id,avg(id) as 平均 from users group by id
select id,avg(id) as 平均 from users group by id,name