【HCK】的博客 select avg(gdprice) -> from goods; (3)max select max() from ; select max(gdprice) -> from goods; (4)min select min() from ; select min(gdprice) -> from goods; (5)count select ,... from group by ; ...
x_minqu的博客 连接查询找出大于等于75分的学生的No、Name、Grade、Courses并且降序 select a.NO,a.Name,b.Grade,b.Courses from test1 as a inner join test2 as b on a.No=b.No where b.Grade>=75 order by Grade desc;...
赤~峰的博客在SELECT 语句中,可以使用ORDER BY子句实现对查询结果的排序。 语法格式为:ORDER BY {列名|表达式|正整数} [ASC|DESC] [,…n] 例如,让商品Goods表以价格降序: SELECT * FROM Goods ORDER BY gdPrice DESC ; ...
碰磕的博客 连接查询找出大于等于75分的学生的No、Name、Grade、Courses并且降序 select a.NO,a.Name,b.Grade,b.Courses from test1 as a inner join test2 as b on a.No=b.No where b.Grade>=75 order by Grade desc;...