你可能感兴趣的试题
UPDATE STUD姓名="王小鱼"WHERE 姓名="王大川" UPDATE STUD姓名="王大川"WHERE 姓名="王小鱼" UPDATE STUD SET 姓名="王小鱼"WHERE姓名="王大川" UPDATE STUD SET姓名="王大川"WHERE姓名="王小鱼"
DELETE STUD WHERE学号="20030019" DELETE FROM STUD WHERE学号="20030019" DELETE TABLE STUD WHERE学号="20030019" DELETE FROM WHERE 学号="20030019"
SELECT*FROM STUD WHERE 姓名 LIKE"张%” SELECT*FROM STUD WHERE 姓名 IN("张%") SELECT*FROM STUD WHERE 姓名 LIKE"张$" SELECT*FROM STUD WHERE 姓名 IN"张$)"
SELECT姓名,入校总分FROM学生表WHERE入校总分>(入校总分WHERE姓名=“王力”) SELECT姓名,入校总分FROM学生表WHERE入校总分>(SELECT入校总分FOR姓名=“王力”) SELECTX.姓名,X.入校总分FROM学生表ASX,学生表ASYWHEREX.入校总分>Y.入校总分ANDY.姓名=“王力” SELECT姓名,入校总分FROM学生表WHERE入校总分IN(SELECT入校总分WHERE姓名=“王力”)
SELECT XM,SAFROM STUD FOR SA<20 SELECT XM,SA FROM STUD WHERE NOT SA>=20 SELECT XM,SA ON STUD FOR SA<20 SELECT XM,SA ON STUD WHERE SA<20
SELECT XM,SA FROM STUD FOR SA<20 SELECT XM,SA FROM STUD WHERE NOT SA>=20 SELECT XM,SA ON STUD FOR SA<20 SELECT XM,SA ON STUD WHERE SA<20
INSERTINTO学生表VALUES(’2006001’,’王小明’,’男’) UPDATE学生表SET姓名=’王莉’WHERE学号=’2006001’ DELETE学生表SET姓名=’王莉’WHERE学号=’2006001’ DELETEFROM学生表WHERE性别=’男’
SELECT * FROM STUD WHERE 姓名LIKE“张%” SELECT * FROM STUD WHERE 姓名IN(“张%”) SELECT * FROM STUD WHERE 姓名LIKE“张$” SELECT * FROM STUD WHERE 姓名IN(“张$)”
。实现该功能的正确SQL语句是______。A) SELECT XM,SA FROM STUD FOR SA<20 SELECT XM,SA FROM STUD WHERE NOT SA>=20 SELECT XM,SA ON STUD FOR SA<20 SELECT XM,SA ON STUD WHERE SA<20