排序:asc:升序(默认)desc:降序1、年龄升序排列select name,age from student order by age;select name,age from student order by age asc;2、年龄降序排列select name,age from student order by age desc;3、先年龄升序,相同的按姓氏首字母升序排列..._数据库查......
文章浏览阅读4.6k次,点赞6次,收藏31次。--mysql数据库的十种查询方式-- (1)查询时起别名SELECT id AS '编号',NAME AS '姓名',age AS '年龄' FROM student;-- (2)查询时添加常量列SELECT id AS '编号',NAME AS '姓名',age AS '年龄','软件工程' AS '班级' FROM......