SQL exercises on employee Database: List the name, job name, department, salary, and grade of the employees according to the department in ascending order

SQL employee Database: Exercise-84 with Solution

[An editor is available at the bottom of the page to write and execute the scripts.]

84. Write a query in SQL to list the name, job name, department, salary, and grade of the employees according to the department in ascending order.

Sample table: employees

Sample table: department

Sample table: salary_grade

Sample Solution:

SELECT e.emp_name,
       e.job_name,
       d.dep_name,
       e.salary,
       s.grade
FROM employees e,
     department d,
     salary_grade s
WHERE e.dep_id = d.dep_id
  AND e.salary BETWEEN s.min_sal AND s.max_sal
ORDER BY e.dep_id ;

Sample Output:

 emp_name | job_name  | dep_name  | salary  | grade
----------+-----------+-----------+---------+-------
 KAYLING  | PRESIDENT | FINANCE   | 6000.00 |     5
 CLARE    | MANAGER   | FINANCE   | 2550.00 |     4
 MARKER   | CLERK     | FINANCE   | 1400.00 |     2
 SANDRINE | CLERK     | AUDIT     |  900.00 |     1
 SCARLET  | ANALYST   | AUDIT     | 3100.00 |     4
 ADNRES   | CLERK     | AUDIT     | 1200.00 |     1
 FRANK    | ANALYST   | AUDIT     | 3100.00 |     4
 JONAS    | MANAGER   | AUDIT     | 2957.00 |     4
 BLAZE    | MANAGER   | MARKETING | 2750.00 |     4
 JULIUS   | CLERK     | MARKETING | 1050.00 |     1
 ADELYN   | SALESMAN  | MARKETING | 1700.00 |     3
 WADE     | SALESMAN  | MARKETING | 1350.00 |     2
 MADDEN   | SALESMAN  | MARKETING | 1350.00 |     2
 TUCKER   | SALESMAN  | MARKETING | 1600.00 |     3
(14 rows)

Practice Online

Sample Database: employee

Have another way to solve this solution? Contribute your code (and comments) through Disqus.

Previous: Write a query in SQL to display the total information of the employees along with grades in ascending order.
Next: Write a query in SQL to list the name, job name, salary, grade and department name of employees except CLERK and sort result set on the basis of highest salary.