DQL语言及用法
DQL(Data Query Language) 数据查询语言,主要是对数据表进行查询操作,用到的动词主要有Select、Where、Order By(Desc Asc)、Group By、Limit。
案例用表创建链接:https://blog.csdn.net/Mr_VanGogha/article/details/106973108
常用动词介绍
动词 | 作用 |
---|---|
Select | 查询动词 |
Where 条件 | 对条件进行判断 |
Order By | 排序,其中Desc为升序,Asc为降序 |
Group By | 分组 |
Limit start len | 第一个返回记录行的偏移量,第二个参数指定返回记录行的最大数目 |
基本语法
1.查询所有的学生
Select * from student;
2.查询学号为001的学生信息(Where)
Select * from student where stuNo = '001';
3.通过学号递减展示所有学生信息(Order By ,Asc为递增,Desc为递减)
Select * from student Order By stuNo Desc;
4.通过性别进行分组(Group By)
Select gender,count(*) as '数量' from student Group By gender;
5.查询性别为男的学生数量
1.Select gender,count(*) as '数量' from student Group By gender having gender = '男';
2.Select gender,count(*) as '数量' from student where gender = '男' Group By gender;