×
单选题
staff的定义如下
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
答案解析
正确答案：A
