下列SQL语句,正确的是()
A.SELECT * TOP 5 FROM table_name
B.SELECT TOP 5% FROM table_name
C.SELECT TOP 5% FROM table_name
D.SELECT TOP 5 PERCENT *FROM table_name
A.SELECT * TOP 5 FROM table_name
B.SELECT TOP 5% FROM table_name
C.SELECT TOP 5% FROM table_name
D.SELECT TOP 5 PERCENT *FROM table_name
A. 看涨(2.00-1.90)*100=10看跌0
B. 看涨0看跌(2.00-1.90)*100=10
C. 看涨0看跌0
D. 看涨(2.00-1.90)*100=10看跌(2.00-1.90)*100=10
A、执行”SELECT *FROM table_name WHERE…”语句后,定会返回所有行的数据
B、WHERE子句在SELECT 子句中为必选
C、在SQL Server中,”!=”与”<>”作用完全相同
D、语句”SELECT *FROM table_name WHERE Age NOT NULL”的写法正确
A、select * from 顾客 where 电话=0
B、select * from 顾客 where 电话=‘’
C、select * from 顾客 where 电话=NULL
D、select * from 顾客 where 电话 IS NULL
A、select distinct 地址from 顾客
B、select unique 地址from 顾客
C、select 地址from 顾客
D、select 地址(unique) from 顾客
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
为了保护您的账号安全,请在“简答题”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!