A、ORDER BY,COMPUTE B、ORDER BY,COMPUTE,COMPUTR BY C、ORDER BY,COMPUTR BY,GROUP BY D、ORDER BY,COMPUTRB BY
A、ORDER BY,COMPUTE B、ORDER BY,COMPUTE,COMPUTR BY C、ORDER BY,COMPUTR BY,GROUP BY D、ORDER BY,COMPUTRB BY
A、 ORDER BY子句可以对多个列进行排序 B、 SELECT语句中,ORDER BY只能单一列进行排序 C、 子查询中也可以使用ORDER BY子句 D、 在视图中可以使用ORDER BY子句
A、A.SELECT productname,price from products order by price ASC B、B.SELECT productname,price from products order by price DESC C、C.SELECT productname,price from products order by price D、D.SELECT productname and price from products order by price DESC
A、SELECT TOP3 FROM scroe ORDER BY math ASC B、SELECT TOP3 FROM scroe ORDER BY math DESC C、SELECT TOP3*FROM scroe ORDER BY math DESC D、SELECT TOP3*FROM scroe ORDER BY math ASC
A、selectCustomerName,SalesDate from Sales group by CustomerName,SalesDate B、select CustomerName,SalesDate from Sales order by CustomerName,SalesDate C、select CustomerName,SalesDate from Sales group by CustomerNameorderbySalesDateDESC D、select CustomerName,SalesDate from Sales order by CustomerName,SalesDateDESC