在SQLServer中,SELECT语句使用()过滤重复行
A.SELECT
B.DISTINCT
C.FROM
D.WHERE
B、DISTINCT
A.SELECT
B.DISTINCT
C.FROM
D.WHERE
B、DISTINCT
A.SELECT*FROMsh_goodsORDERBYpriceDESC,cat_id;
B.SELECT*FROMsh_goodsORDERBYprice,cat_id;
C.SELECT*FROMsh_goodsORDERBYcat_id,priceDESC;
D.SELECT*FROMsh_goodsORDERBYcat_idDESC,price;
A.SELECT ename, sal FROM EMP
B.SELECT ename,sal, sal+100 FROM emp
C.SELECT ename,sal,12*sal+100 FROM emp
D.SELECT ename,sal,12*(sal+100)FROM EMP
A.select top 5 from goods order by price desc
B.select top 5 * from goods group by price desc
C.select top 5 * from goods group by price
D.select top 5 * from goods order by price desc
A.只能在UPDATE语句和DELETE语句中使用,不能在INSERT语句中使用
B.可以在UPDATE语句、DELETE语句和INSERT语句中使用
C.在UPDATE语句中,子查询不能放置在WHERE条件中
D.在INSERT语句中使用子查询的句法格式为:INSERT INTO 表名1(字段)SELECT字段列表FROM表名2,其中表名1与表名2为同一张表
A.聚合表
B.分片表
C.全局表
D.单表