你可能感兴趣的试题
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学号