示例:表 user_profile:
id | device_id | gender | age | university | gpa |
1 | 2138 | male | 21 | 北京大学 | 3.4 |
2 | 3214 | male | 23 | 复旦大学 | 4 |
3 | 6543 | female | 20 | 北京大学 | 3.2 |
4 | 2315 | female | 23 | 浙江大学 | 3.6 |
5 | 5432 | male | 25 | 山东大学 | 3.8 |
6 | 2131 | male | 28 | 北京师范大学 | 3.3 |
1、查询结果去重:SELECT distinct university FROM user_profile;
2、查询结果限制返回行数:SELECT device_id FROM user_profile limit 2;
3、将查询后的列重新命名:SELECT device_id as user_infos_example FROM user_profile limit 2;
4、查找后排序:SELECT device_id,age FROM user_profile order by age asc;
5、 查找后多列排序:SELECT device_id,gpa,age FROM user_profile ORDER BY gpa, age asc;
6、查找后降序排列:SELECT device_id,gpa,age FROM user_profile ORDER BY gpa DESC,age DESC; //谁在前优先级高,先排序gpa ,gpa 相同的情况下再排序age