SQL Exercise: Find those employees who earn below 6000

Last update on January 08 2026 12:47:32 (UTC/GMT +8 hours)

1. From the following table, write a SQL query to find those employees whose salaries are less than 6000. Return full name (first and last name), and salary.

Sample table: employees

+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
| EMPLOYEE_ID | FIRST_NAME  | LAST_NAME   | EMAIL    | PHONE_NUMBER       | HIRE_DATE  | JOB_ID     | SALARY   | COMMISSION_PCT | MANAGER_ID | DEPARTMENT_ID |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+
|         100 | Steven      | King        | SKING    | 515.123.4567       | 2003-06-17 | AD_PRES    | 24000.00 |           0.00 |          0 |            90 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | 2005-09-21 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | 2001-01-13 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | 2006-01-03 | IT_PROG    |  9000.00 |           0.00 |        102 |            60 |
|         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | 2007-05-21 | IT_PROG    |  6000.00 |           0.00 |        103 |            60 |
|         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | 2005-06-25 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | 2006-02-05 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | 2007-02-07 | IT_PROG    |  4200.00 |           0.00 |        103 |            60 |
|         108 | Nancy       | Greenberg   | NGREENBE | 515.124.4569       | 2002-08-17 | FI_MGR     | 12008.00 |           0.00 |        101 |           100 |
|         109 | Daniel      | Faviet      | DFAVIET  | 515.124.4169       | 2002-08-16 | FI_ACCOUNT |  9000.00 |           0.00 |        108 |           100 |
......
|         206 | William     | Gietz       | WGIETZ   | 515.123.8181       | 2002-06-07 | AC_ACCOUNT |  8300.00 |           0.00 |        205 |           110 |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+

View the table

Sample Solution:

-- Selecting a concatenated string of 'first_name' and 'last_name' as 'Full_Name' and the 'salary' column from the 'employees' table
SELECT first_name || ' ' || last_name AS Full_Name, salary
-- Specifying the table to retrieve data from ('employees')
FROM employees
-- Filtering the results based on the condition that 'salary' is less than 6000
WHERE salary < 6000;

Sample Output:

     full_name     | salary
-------------------+---------
 David Austin      | 4800.00
 Valli Pataballa   | 4800.00
 Diana Lorentz     | 4200.00
 Alexander Khoo    | 3100.00
 Shelli Baida      | 2900.00
 Sigal Tobias      | 2800.00
 Guy Himuro        | 2600.00
 Karen Colmenares  | 2500.00
 Kevin Mourgos     | 5800.00
 Julia Nayer       | 3200.00
 Irene Mikkilineni | 2700.00
 James Landry      | 2400.00
 Steven Markle     | 2200.00
 Laura Bissot      | 3300.00
 Mozhe Atkinson    | 2800.00
 James Marlow      | 2500.00
 TJ Olson          | 2100.00
 Jason Mallin      | 3300.00
 Michael Rogers    | 2900.00
 Ki Gee            | 2400.00
 Hazel Philtanker  | 2200.00
 Renske Ladwig     | 3600.00
 Stephen Stiles    | 3200.00
 John Seo          | 2700.00
 Joshua Patel      | 2500.00
 Trenna Rajs       | 3500.00
 Curtis Davies     | 3100.00
 Randall Matos     | 2600.00
 Peter Vargas      | 2500.00
 Winston Taylor    | 3200.00
 Jean Fleaur       | 3100.00
 Martha Sullivan   | 2500.00
 Girard Geoni      | 2800.00
 Nandita Sarchand  | 4200.00
 Alexis Bull       | 4100.00
 Julia Dellinger   | 3400.00
 Anthony Cabrio    | 3000.00
 Kelly Chung       | 3800.00
 Jennifer Dilly    | 3600.00
 Timothy Gates     | 2900.00
 Randall Perkins   | 2500.00
 Sarah Bell        | 4000.00
 Britney Everett   | 3900.00
 Samuel McCain     | 3200.00
 Vance Jones       | 2800.00
 Alana Walsh       | 3100.00
 Kevin Feeney      | 3000.00
 Donald OConnell   | 2600.00
 Douglas Grant     | 2600.00
 Jennifer Whalen   | 4400.00
(50 rows)

Code Explanation:

The said query in SQL which retrieves the full name (concatenation of first name and last name with a space in between) and salary columns of employees whose salary is less than 6000.
The result will be a table with two columns: "Full_Name" and "salary", with each row representing an employee that meets the condition.

Go to:

PREV : SQL SORTING and FILTERING on HR Database Exercises Home
NEXT : Find those employees who earn more than 8000.

Practice Online