18. List out the employee id, last name in ascending order based on the employee id.
Select employee_id, last_name from employee order by employee_id
19. List out the employee id, name in descending order based on salary column
Select employee_id, last_name, salary from employee order by salary desc
20. list out the employee details according to their last_name in ascending order and salaries in descending order
Select employee_id, last_name, salary from employee order by last_name, salary desc
21. list out the employee details according to their last_name in ascending order and then on department_id in descending order.
No comments:
Post a Comment