数据库中有一张表名为Emp,包含有如下列:EmpNO(雇员编号,Varchar(20),Pk),Job(职位Varchar(10)),HirDate(雇佣日期,Date),Sal(月薪,Float)。要求查询全部雇员信息,并按工资升序降序,如果工资相同,则按雇佣日期由早到晚排序
A、Select * From EMP Order HirDate
B、Select * From Emp Order By SAL Desc,HireDate Asc
C、Select * From Emp Order By SAL Asc,HireDate Asc
D、Select * From Emp Order By SAL Desc,HireDate Desc