staff的定义如下
id INTEGER
name CHAR(20)
dept INTEGER
job CHAR(20)
years INTEGER
salary DECIMAL(10,2)
comm DECIMAL(10,2)
下面哪个语句可以按照job和salary的升序排序来返回所有员工的
ASELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 4,6
BSELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 4,6
CSELECT id,name,salary,dept,job,years,comm FROM staff ORDER BY 5,3
DSELECT id,name,salary,dept,job,years,comm FROM staff GROUP BY 5,3