查询所有顾客的地址信息,有重复的地址只显示一个,使用的SQL语句为:()
A、select distinct 地址from 顾客
B、select unique 地址from 顾客
C、select 地址from 顾客
D、select 地址(unique) from 顾客
A、select distinct 地址from 顾客
B、select unique 地址from 顾客
C、select 地址from 顾客
D、select 地址(unique) from 顾客
+----+------------------+
| Id | Email |
+----+------------------+
| 1 | john@example.com |
| 2 | bob@example.com |
| 3 | john@example.com |
+----+------------------+
Id 是这个表的主键
A. 每个数据库表可以建立多个聚集索引
B. 每个表可以定义多个非聚集索引
C. 索引的数据保存在同一个表中
D. 索引不会改变表中的数据
A、select * from 顾客 where 地址 like ‘江苏省%市%’
B、select * from 顾客 where 地址 = ‘江苏省%市%’
C、select * from 顾客 where 地址 like ‘江苏省__市%’
D、select * from 顾客 where 地址 = ‘江苏省__市%’
A、SELECT TOP 10 SUM(UnitPrice) AS单价之和FROM Products
B、SELECT SUM(UnitPrice) AS单价之和TOP 10 FROM Products
C、SELECT TOP 10 COUNT(UnitPrice) AS单价之和FROM Products
D、SELECT SUM(UnitPrice) TOP 10 AS单价之和FROM Products
A、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 6 AND 10
B、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
C、SELECT Name,UnitPrice FROM Products WHERE UnitPrice BETWEEN 10 AND 6
D、SELECT Name,UnitPrice FROM Products WHERE UnitPrice>6 AND UnitPrice <10<br>
A、SELECT MIN (UnitPrice) AS最高单价FROM Products
B、SELECT AVG (UnitPrice) AS最高单价FROM Products
C、SELECT MAX (UnitPrice) AS最高单价FROM Products
D、SELECT MAX UnitPrice AS最高单价FROM Products
A、select avg(price),type from book group by type
B、select count(price),type from book group by price
C、select avg(price),type from book group by price
D、select count (price),type from book group by type
A、select cid,count(distinct(cid)),sum(money) from orders group by cid
B、select cid,count(distinct(cid)),sum(money) from orders order by cid
C、select cid,count(cid),sum(money) from orders order by cid
D、select cid,count(cid),sum(money) from orders group by cid
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!