当前位置:百科知识 > 优学院问答

问题描述:

[多选] “查询与‘刘晨’在同一个系学习的学生”的SQL语句为()。
A.SELECT SNO, SNAME, SAGE, SSEX, SDEP FROM S WHERE SDEP IN (SELECT SDEP FROM S WHERE SNAME = "刘晨") B.SELECT * FROM S WHERE SDEP IN (SELECT SDEP FROM S WHERE SNAME ="刘晨") C.SELECT SNO, SNAME, SAGE, SSEX, SDEP FROM S WHERE SNAME = "刘晨" D.SELECT S1.SNO, S1.SNAME, S1.SAGE, S1.SSEX, S1.SDEP FROM S S1, S S2 WHERE S1.SDEPT = S2.SDEPT AND S2.SNAME = "刘晨"
参考答案:查看
答案解析:
☆收藏

随机题目