当前位置: X题卡 > 所有题目 > 题目详情

在学生选课表(SC)中,查询选修了3号课程(课程号CH)的学生的学号(XH)及其成绩(GD)。查询结果按分数的降序排列。实现该功能的正确SQL语句______。

查看本题答案

你可能感兴趣的试题

SELECT XH,GD FROM SC
WHERE CH='3' ORDER BY GD DESC://  
SELECT XH,GD FROM SC
WHERE CH='3' ORDER BY GD ASC;  
SELECT XH,GD FROM SC
WHERE CH='3' GROUP BY GD DESC://  
SELECT XH,GD FROM SC
WHERE CH='3' GROUP BY GD ASC://  
SELECT学号,课程号FROM SC WHERE 成绩 IS NULL  SELECT学号,课程号FROM SC WHERE成绩IS NOT NULL  SELECT学号,课程号FROM SC WHERE成绩=NOT NULL  SELECT学号,课程号FROM SC WHERE成绩=NULL  
SELECT XH,GD FROM SC WHERE CH="3"ORDER BY GD DESC  SELECT XH,GD FROM SC WHERE CH="3"ORDER BY GD ASC  SELECT XH,GD FROM SC WHERE CH="3"GROUP BY GD DESC  SELECT XH,GD FROM SC WHERE CH="3"GROUP BY GD ASC  
SELECT XH,GD FROM SC WHERE CH=“3”ORDER BY GD DESC  SELECT XH,GD FROM SC WHERE CH=“3”ORDER BY GD ASC  SELECT XH,GD FROM SC WHERE CH=“3”GROUP BY GD DESC  SELECT XH,GD FROM SC WHERE CH=“3”GROUP BY GD ASC  
SELECR XH,GD FROM SC
WHERE CH='3' ORDER BY GD DESC://  
SELECT XH,GD FROM SC
WHERE CH='3' ORDER BY GD ASC;  
SELECT XH,GD FROM SC
WHERE CH='3'GROUP BY GD DESC;  
SELECT XH,GD FROM SC
WHERE CH='3' GROUP BY GD ASC;  
SELECT XH,GD FROM SC WHERE CH='3'ORDER BY GD DESC  SELECT XH,GD FROM SC WHERE CH='3'ORDER BY GD ASC  SELECT XH,GD FROM SC WHERE CH='3'GROUP BY GD DESC  SELECT XH,GD FROM SC WHERE CH='3'GROUP BY GD ASC  
SELECT XH, GD FROM SC
WHERE CH='3' ORDER BY GD DESC;  
SELECT XH, GD FROM SC
WHERE CH='3' ORDER BY GD ASC;  
SELECT XH, GD FROM SC
WHERE CH='3' GROUP BY GD DESC;  
SELECT XH, GD FROM SC
WHERE CH='3' GROUP BY GD ASC;  
SELECT 学号,课程号 FROM SC WHERE 成绩 IS NULL  SELECT 学号,课程号 FROM SC WHERE 成绩 IS NOT NULL  SELECT 学号,课程号 FROM SC WHERE 成绩=NOT NULL  SELECT 学号,课程号 FROM SC WHERE 成绩=NULL  
SELECT XH,GD FROM SC://   WHERE CH='3F' ORDER BY GD DESC  SELECT XH,GD FROM SC;   WHERE CH='3'ORDER BY GD ASC  SELECT XH,GD FROM SC;   WHERECH='3'GROUP BY GD DESC  SELECTXH,GDFROMSC;   WHERE CH='3'GROUP BY GD ASC  
SELECT XH, CJFROM SC WHERE CH=′3′ORDER BY CJDESC  SELECT XH, CJ FROM SC WHERE CH=′3′ORDER BY CJ ASC  SELECT XH, CJ FROM SC WHERE CH=′3′GROUP BY CJ DESC  SELECT XH, CJFROM SC WHERE CH=′3′GROUP BY CJ ASC  
SELECT XH,GD FROM SC:// WHERE CH='3F' ORDER BY GD DESC  SELECT XH,GD FROM SC; WHERE CH='3'ORDER BY GD ASC  SELECT XH,GD FROM SC; WHERECH='3'GROUP BY GD DESC  SELECTXH,GDFROMSC; WHERE CH='3'GROUP BY GD ASC  
SELECT XH,CJ FROM SC WHERE CH='3'ORDER BY CJ DESC  SELECT XH,CJ FROM SC WHERE CH='3'ORDER BY CJ ASC  SELECT XH,CJ FROM SC WHERE CH='3'GROUP BY CJ DESC  SELECT XH,CJ FROM SC WHERE CH='3'GROUP BY CJ ASC  
SELECT XH,GD FROM SC://
WHERE CH='3F' ORDER BY GD DESC  
SELECT XH,GD FROM SC;
WHERE CH='3'ORDER BY GD ASC  
SELECT XH,GD FROM SC;
WHERECH='3'GROUP BY GD DESC  
SELECTXH,GDFROMSC;
WHERE CH='3'GROUP BY GD ASC
  
SELECR XH,GD FROM SC WHERE CH='3' ORDER BY GD DESC://  SELECT XH,GD FROM SC WHERE CH='3' ORDER BY GD ASC;  SELECT XH,GD FROM SC WHERE CH='3'GROUP BY GD DESC;  SELECT XH,GD FROM SC WHERE CH='3' GROUP BY GD ASC;  
SELECT 学号 FROM SC GROUP BY 学号 HAVING SUM (*)>3  SELECT 学号 FROM SC GROUP BY 学号 HAVING COUNT(*)>3  SELECT 学号 FROM SC GROUP BY 学号 HAVING 课程号>3  SELECT 学号 FROM SC WHERE 课程号>3 GROUP BY学号  

热门试题

更多