你可能感兴趣的试题
SELECT * FROM student SELECT * FROM student WHERE GETDATE() SELECT * FROM student ORDER st_id SELECT * FROM student BY St_name
DROP FROM student DELETE FROM student REMOVE FROM student KILL FROM student
SELECT * FROM student WHERE sname LIKE'刘 * ' SELECT * FROM student WHERE sname LIKE'刘 $' SELECT * FROM student WHERE sname LIKE'刘%' SELECT * FROM student WHERE sname LIKE'刘&'
SELECT学号,姓名 FROM student WHERE成绩<=100.AND.成绩>=60 SELECT学号,姓名 FROM student WHERE成绩<100.AND.成绩>60 SELECT学号,姓名 FROM student WHERE成绩>=100.AND.成绩<=60 SELECT学号,姓名 FROM student WHERE成绩>100.AND.成绩<60
cheat cheated cheating to cheat
>19Hu >15Hu >13Hu >23Hu >25Hu
>19HU >15HU >13HU >23HU >25HU
20HU 25~32HU 0~10HU 30~40HU 50~70HU
DROP FROM Student WHERE 学号="1001" DROP FROM Student FOR 学号="1001" DELETE FROM Student WHERE 学号="1001" DELETE FROM Student FOR 学号="1001"
20HU 25~32HU 0~10HU 30~40HU 50~70HU
SELECT 学号,姓名 FROM student WHERE 成绩<=100.AND.成绩>=60 SELECT 学号,姓名 FROM student WHERE 成绩<100.AND.成绩>60 SELECT 学号,姓名 FROM student WHERE 成绩>=100.AND.成绩<=60 SELECT 学号,姓名 FROM student WHERE 成绩>100.AND.成绩<60
DROP FROM Student WHERE学号="1001" DROP FROM Student FOR学号="1001" DELETE FROM Student WHERE学号="1001" DELETE FROM Student FOR学号="1001"
-50HU左右 -25~5HU 12~30HU 35~80HU 80~120HU
-50HU左右 -25~5HU 12~30HU 35~80HU 80~120HU
60HU、20HU 150HU、25HU 400HU、35HU 80~100HU、35HU 1000~1500HU、350HU
SELECT( * )FROM STUDENT WHERE AVE < 80 SELECT( * ) FROM STUDENT HAVING AVE < 80 SELECT(AVE) FROM STUDENT WHERE AVE < 80 SELECT(AVE) FROM STUDENT HAVING AVE < 80
SELECT( * )FROM STUDENT WHERE AVE < 80 SELECT( * ) FROM STUDENT HAVING AVE < 80 SELECT(AVE) FROM STUDENT WHERE AVE < 80 SELECT(AVE) FROM STUDENT HAVING AVE < 80
SELECT*FROM STUDENT WHERE LEFT(姓名,2)=“王” SELECT*FROM STUDENT WHERE RIGHT(姓名,2)=“王” SELECT*FROM STUDENT WHERE TRIM(姓名,2)=“王” SELECT*FROM STUDENT WHERE STR(姓名,2)=“王”