基于“学生—选课—课程”数据库中的三 个关系是：
S(S#,SNAME,SEX,AGE),SC(S#,C#,GRADE),C(C#,CNAME,TEACHER) 若要求查找‘李’姓学生的学生号和姓名，正确的SQL语句是______。
A．SELECTS#,SNAMEFROMSWHERE SNAME=’李%’
B．SELECTS#,SNAMEFROMSWHERE SNAMELIKE’李%’
C．SELECTS#,SNAMEFROMSWHERE SNAME=’%李%’
D．SELECTS#,SNAMEFROMSWHERE SNAMELIKE’%李%’
参考答案：B
解析：SELECT S#,SNAME FROM S WHERE SNAME LIKE ’李%’只有这个查询语句可以查找’李’姓学生的学生号和姓名。“%”的意思为后面可以跟任何字符。
| 口语社区, 根据上下文,完成对话。 | |
D: What's the trouble with you? P: I've  got a terrible headache.D: (1) _____ P: One day I went outdoors in a heavy rain, and then it started. D: (2) _____ P: It's already been for a few days, and it gets worse and worse. D: (3)_____ P: My wife took my temperature last night. She told me that it was 38.5?. D: Let me check your pulse(把脉) and listen to your heart. (4) _____ P: Is it serious? D: Oh, no. Drink plenty of warm water or juice, stay in bed for several days and keep warm. P: Thank you, doctor. (5) _____ D: Please go to the injection room(注射室) and ask my nurse to give you an injection for your fever. P: OK. Goodbye, doctor. 1_____ 2_____ 3_____ 4_____ 5_____ |