SQL语句实战练习-group,count,left join,别名
需求1:vehicle表统计车组group下的车辆vehicle数量
SQL语句:SELECT groupId,COUNT(*) FROM vehicle GROUP BY groupId
需求2:vehicle表统计车组group下的车辆vehicle数量,并按照车辆数量降序排序
SQL语句:SELECT groupId,COUNT(*) AS vehicle_number FROM vehicle GROUP BY groupId ORDER BY vehicle_number DESC
需求3:veh
原创
2021-07-22 15:32:59 ·
155 阅读 ·
0 评论