SQL习题与.pptVIP

5.设有关系表R: R(BH,XM,XB,DWH) (1)实现 的SQL语句是_____. (2)实现∏XM,XB(R) 的SQL语句是______. (3)实现 的SQL语句是______. 答:①SELECT * FROM R WHERE DWH=‘100’ ②SELECT XM,XB FROM R ③SELECT XM,DWH FROM R WHERE XB=‘女’ R(NO,NAME,SEX,AGE,CLASS) (2)插入’95031’班学号为30,姓名为’郑和’的学生记录:_____. INSERT INTO R(NO,NAME,CLASS) VALUES (30, ’郑和’, ’95031’) R(NO,NAME,SEX,AGE,CLASS) (3)将学号为10的学生姓名改为’王华’:_____. UPDATE R SET NAME=‘王华’ WHERE NO=10 R(NO,NAME,SEX,AGE,CLASS) (