题海让大学四年没有难题
白天模式登陆

题目详情

单选题 列出居住在MA或者DC州的所有的出版商,其SELECT语句是( )

A. SELECT Pub_Name,City FROM Publishers WHERE State = ('MA','DC')

B. SELECT Pub_Name,City FROM Publishers WHERE State IN ('MA','DC')

C. SELECT Pub_Name,City FROM Publishers WHERE State BETWEEN 'MA' AND 'DC'

D. SELECT Pub_Name,City FROM Publishers WHERE State='MA' AND State='DC'

MySQL数据库应用课程封面

学科：MySQL数据库应用

时间：2024-04-26 01:38:06

相关题目

相关作业

题目1
单选题
MySQL数据库中使用SQRT(X)返回X的平方根,SQRT(16)返回的结果是( )
A. 2B. 4C. 8D. 16
题目2
单选题
下列的( )子句在SELECT语句中用于排序结果集
A. havingB. whereC. fromD. order by
题目3
单选题
设有图书管理数据库: 图书(总编号C(6),分类号C(8),书名C(16),作者C(6),出版单位C(20),单价N(6,2)) 读者(借书证号C(4),单位C(8),姓名C(6),性别C(2),职称C(6),地址C(20)) 借阅(借书证号C(4),总编号C(6),借书日期D(8))对于图书管理数据库,检索借阅了《现代网络技术基础》一书的借书证号.下面SQL语句正确的是( ).SELECT 借书证号 FROM 借阅 WHERE 总编号=__________________________________
A. (SELECT 借书证号 FROM 图书 WHERE 书名="现代网络技术基础")B. (SELECT 总编号 FROM 图书 WHERE 书名="现代网络技术基础")C. (SELECT 借书证号 FROM 借阅 WHERE 书名="现代网络技术基础")D. (SELECT 总编号 FROM 借阅 WHERE 书名="现代网络技术基础")
题目4
单选题
下列( )函数可以把一个列中的所有值求平均值
A. MAXB. SUMC. COUNTD. AVG
题目5
单选题
列出居住在MA或者DC州的所有的出版商,其SELECT语句是( )
A. SELECT Pub_Name,City FROM Publishers WHERE State = ('MA','DC')B. SELECT Pub_Name,City FROM Publishers WHERE State IN ('MA','DC')C. SELECT Pub_Name,City FROM Publishers WHERE State BETWEEN 'MA' AND 'DC'D. SELECT Pub_Name,City FROM Publishers WHERE State='MA' AND State='DC'
题目6
单选题
如果用户想要查询user表中第11~20条的记录,( )选项的SELECT语句是最合适的
A. SELECT * FROM user WHERE userId BETWEEN 11 AND 20B. SELECT * FROM user WHERE userId >=11 AND userId<=20C. SELECT * FROM user LIMIT 10,10D. SELECT * FROM user WHERE userId in(11,12,13,14,15,16,17,18,19,200
题目7
单选题
下列选项中,实现分页(每页显示10条)显示test表中的数据,并获取第2页数据的SQL语句是( )
A. SELECT * FROM test LIMIT 10,10B. SELECT * FROM test LIMIT 11,10C. SELECT * FROM test LIMIT 10,20D. SELECT * FROM test LIMIT 11,20
题目8
单选题
如果用户想要查询user表中第11~20条的记录,( )选项的SELECT语句是最合适的
A. SELECT * FROM user WHERE userId BETWEEN 11 AND 20B. SELECT * FROM user WHERE userId >=11 AND userId<=20C. SELECT * FROM user LIMIT 10,10D. SELECT * FROM user WHERE userId in(11,12,13,14,15,16,17,18,19,200)
题目9
单选题
SQL 查询中去除重复数据的是( )
A. ORDER BYB. GROUP BYC. DISTINCTD. DESC
题目10
单选题
查询报纸名字中包含"Texas Times"的报纸的材料,合适的查询语句是( )
A. SELECT * FROM NewspaperWHERE NewspaperName LIKE '%Texas Times%'B. SELECT * FROM NewspaperWHERE NewspaperName LIKE 'Texas Times'C. SELECT * FROM NewspaperWHERE NewspaperName LIKE 'Texas Times%'D. SELECT * FROM NewspaperWHERE NewspaperName LIKE '[Texas Times]'
Copyright © 2022 津ICP备2021001502号