登陆

题目详情

单选题下列的( )子句在SELECT语句中用于排序结果集

A. having

B. where

C. from

D. order by

学科：MySQL数据库应用

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

相关题目
相关作业

MySQL数据库中使用SQRT(X)返回X的平方根,SQRT(16)返回的结果是( )

A. 2B. 4C. 8D. 16

下列的( )子句在SELECT语句中用于排序结果集

A. havingB. whereC. fromD. order by

设有图书管理数据库: 图书(总编号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 书名="现代网络技术基础")

下列( )函数可以把一个列中的所有值求平均值

A. MAXB. SUMC. COUNTD. AVG

列出居住在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'

如果用户想要查询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

下列选项中,实现分页(每页显示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

如果用户想要查询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)

SQL 查询中去除重复数据的是( )

A. ORDER BYB. GROUP BYC. DISTINCTD. DESC

查询报纸名字中包含"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

拍照搜题更快捷

海量题库
无搜索限制
快捷拍照搜题

扫描他！然后带走我～