你可能感兴趣的试题
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 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学号
湘公网安备 43130202000226号