How can I write a SQL query for categorizing the salary of employees in SQL?

Question

I am assigned a task which is related to analyzing data in SQL. In this task, there is a table whose name is “employees” with the following columns: “employee_id” “employee_name” and “salary”. How can I write an SQL query for categorizing employees' salaries based on the categories of low, medium, and high? Here are the following criteria:

If the salary is less than 30000 then it should be counted as low
If the salary is between 30000 and 60000 then it should be counted as medium
If the salary is above 60000 then it should be categorized as high.

The query should retrieve the “employee_name” and their respective category.

Daniel Baker · Accepted Answer

In the context of SQL, you can achieve your objective by using the multiple CASE WHEN function in SQL.

Here is the SQL query for getting the specified categorization:

SELECT 
    Employee_name,
    CASE 
        WHEN salary < 30000> 60000 THEN ‘High’
    END AS salary_category
FROM

Employees;

This above query will certainly use the CASE WHEN statement for categorizing the salary of employees based on the provided criteria as low, medium and high. The results would include the “employee name” and their respective “salary_category”.

How can I write a SQL query for categorizing the salary of employees in SQL?

About this question

Your answer

1 Answer

More SQL Server discussions

Learn & Explore

SQL Server Tutorials

SQL Server Interview Q&A

Latest SQL Server Blogs

Want answers to more SQL Server questions?

Stay in the loop — it’s free

You’re on the list!