lastName in ASC and Salary in Desc Order in a SQL Table

Thank you , The code is working properly

Sir this code is working

but the lastName ASC is not working in  output.

The output is:-

 

employeeId       lastName             firstName            middleName           jobId            managerId        hireDate                salary           comm        departmentId    
---------------- -------------------- -------------------- -------------------- ---------------- ---------------- ----------------------- ---------------- ----------- ----------------
7505     DOYLE     JEAN        K     671    7839    4/4/1985      2850        30              
7506     DENNIS    LYNN       S     671    7839    10/5/1985     2750       30              
7507     BAKER     LESLIE      D     671    7839   9/6/1985       2200       40              
7499     ALLEN      KEVIN      J     670    7698    12/4/1984     1600      300       30              
7521     WARK     CYNTHIA   D     670    7698    4/2/1985      1250      500       30              
7369     SMITH     JOHN       Q     667    7902    12/5/1984     800         20              


please send me the corrected code

try it,



select * from tbl_Employee order by Salary desc,lastName asc