软件测试常用SQL查询语句(一）

一、简单查询

from > distinct > select > order by > limit

(1) 普通查询：select name,age from students;

(2) 起别名查询：select s.name,s.age from students as s;

(3) 分页查询：select name,age from students limit 0，10;

(4)排序查询：select name,age,id from students order by age desc,id asc;

(5)去重查询：select distinct age from students;

二、条件查询

from > where > distinct > select > distinct > order by > limit

eg: select name,age, from students where name=‘xiaoming’ and age=18;

三、高级查询（聚合函数）

sum求和 | avg平均数 | max最大数 | 最小数min
group by | 分组查询

(1) 求班级男女平均年龄分别为多少？
select sex