SQL Exercise: Employees according to the department in ASC 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. From the following table, write a SQL query to find the employees according to the department in ascending order. Return name, job name, department, salary, and grade.
Sample table: employees
Sample table: department
Sample table: salary_grade
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 ;
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)
The said query in SQL that retrieves the employee name, job name, department name, salary, and salary grade for each employee who falls within a certain salary range and belongs to a department, and orders the results by department ID.
A join happens by matching the 'employees' and 'department' tables based on the department ID column and the 'employees' and 'salary_grade' tables matches the salary falls within the salary range of the salary grade. This orders the results by the department ID.
Sample Database: employee
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous SQL Exercise: List the employees along with grades in ascending order.
Next SQL Exercise: Sort on highest salary of employees except CLERK.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.
SQL: Tips of the Day
MySQL select 10 random rows from 600K rows fast:
SELECT name FROM random AS r1 JOIN (SELECT CEIL(RAND() * (SELECT MAX(id) FROM random)) AS id) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 1
- Weekly Trends
- Java Basic Programming Exercises
- SQL Subqueries
- Adventureworks Database Exercises
- C# Sharp Basic Exercises
- SQL COUNT() with distinct
- Java Collection Exercises
- SQL COUNT() function
- SQL Inner Join
- Python Tutorial
- Python Array Exercises
- SQL Cross Join
- C# Sharp Array Exercises
We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook