要找出籍贯是湖北或湖南的学生的姓名和性别,下述SQL语句正确的有哪三项()。
- A、SELECT Sname,Ssex FROM Student WHERE Sdept=(‘湖南’,‘湖北’);
- B、SELECT Sanme,Ssex FROM Student WHERE Sdept=’湖南’ORSdept=’湖北’;
- C、SELECT Sname,Ssex FROM Student WHERE Sdep tLIKE‘湖%’
- D、SELECT Sname,Ssex FROM Student WHERE Sdept LIKE‘%湖’;
- E、SELECT Sname,Ssex FROM Student WHERE Sdept IN(‘湖南’,‘湖北’);
正确答案:B,C,E
答案解析:有
微信扫一扫手机做题