A、SELECT XH,GD FROM SC: WHERE CH='3F' ORDER BY GD DESC
B、SELECT XH,GD FROM SC; WHERE CH='3'ORDER BY GD ASC
C、SELECT XH,GD FROM SC; WHERECH='3'GROUP BY GD DESC
D、SELECTXH,GDFROMSC; WHERE CH='3'GROUP BY GD ASC
查看答案
正确答案
试题解析
解析:可以用ORDER BY子句对查询结果进行排列,其中ASC表示升序,DESC表示降序。而GROUP BY子句是指对查询结果按某一列或多列值进行分组,值相等的为一组。