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

Question

Sir I have a Table name tbl_Employee the Colums to this table is emp.Id lastnamefirstNamemiddleNamejobIdmanagerIdhireDate salarycommissiondepartmentId I want to display all details in ASC order according to lastName and Salary in DESC order. Is this possible?. if yes send me the code.

Pankaj Pandey · Answer

try it.. select * from tbl_Employee order by lastName asc Salary desc

Bineesh VP · Answer

Thank you  The code is working properly

Bineesh VP · Answer

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

Pankaj Pandey · Answer

try it select * from tbl_Employee order by Salary desc lastName asc