题解 | 查找后降序排列
SELECT device_id, gpa, age FROM user_profile ORDER BY gpa DESC, age DESC
select 查询结果 [设备ID,gpa,年龄]
from 从哪张表中查找数据 [user_profile]
order by 对查询结果排序 [按照gpa、年龄降序排序]
SELECT device_id, gpa, age FROM user_profile ORDER BY gpa DESC, age DESC
select 查询结果 [设备ID,gpa,年龄]
from 从哪张表中查找数据 [user_profile]
order by 对查询结果排序 [按照gpa、年龄降序排序]
相关推荐