<{p}>[单选]数据库中有"teachers"表,表的部分字段如下<{br/}>序号 字段 备注<{br/}>1 xnum 系号<{br/}>2 salary 工资<{br/}>SQL语句:SELECT * FROM teachers WHERE salary BETWEEN (SELECT AVG(salary) FROM teachers) AND (SELECT MAX(salary) FROM teachers)<{br/}>与如上语句等价的SQL语句是______。()<{br/}><{/p}>

发布于 2021-04-23 17:07:43
【单选题】
A <{p}>SELECT * FROM teachers WHERE salary<= (SELECT MAX(salary) FROM teachers)<{/p}>
B <{p}>SELECT * FROM teachers WHERE salary >=(SELECT MIN(salary) FROM teachers)<{/p}>
C <{p}>SELECT * FROM teachers WHERE salary>= (SELECT AVG(salary) FROM teachers)<{/p}>
D <{p}>SELECT * FROM teachers WHERE salary<= (SELECT AVG(salary) FROM teachers)<{/p}>

查看更多

关注者
0
被浏览
66
  • 体验AI问答!更聪明、超智能!
  • 一款基于GPT的超级AI助手,可以对话、创作、写文案!
1 个回答

撰写答案

请登录后再发布答案,点击登录

发布
问题

手机
浏览

扫码手机浏览

分享
好友

在线
客服