Group by 为()语句。
A、排序语句
B、分组语句
C、排名语句
A、排序语句
B、分组语句
C、排名语句
A、GROUP BY WHERE HAVING B、WHE REGROUP BY HAVING C、WHE REHAVING GROUP BY D、HAVING WHERE GROUP BY
A、ORDER BY,COMPUTE B、ORDER BY,COMPUTE,COMPUTR BY C、ORDER BY,COMPUTR BY,GROUP BY D、ORDER BY,COMPUTRB BY
A、这个语句是符合语法的 B、这个语句是不能执行的,因为缺少HAVING子句 C、这个语句是不能执行的,因为分组的条件列不在SELECT列表中 D、这个语句是不能执行的,因为GROUP BY子句应该在主查询中,而不是在子查询中 E、在主查询的WHERE条件中,不应该用IN,而应该用等号
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