登陆题目详情
单选题 SQL 查询中去除重复数据的是( )
学科：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]'
下载 题海APP
拍照搜题更快捷
- 海量题库
- 无搜索限制
- 快捷拍照搜题
