staff的定义如下 id INTEGER name CHAR(20) dept INTEGER job CHAR(20) years INTEGER salary DECIMAL(10,2) comm DECIMAL(10,2) 下面哪个语句可以按照job和salary的升序排序来返回所有员工的
A.SELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 4,6 B.SELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 4,6 C.SELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 5,3 D.SELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 5,3正确答案C
