PostgreSQL Basic SELECT Statement: Select first ten records from a table

Last update on February 07 2026 12:19:10 (UTC/GMT +8 hours)

18. Write a query to select first ten records from a table.

Sample Solution:

Code:

-- Selecting the employee ID and first name from the employees table, limiting the result to the first 10 rows
SELECT employee_id, first_name 
-- Selecting data from the employees table
FROM employees  
-- Limiting the result set to the first 10 rows
LIMIT 10;

Explanation:

This SQL code selects the employee ID and first name from the "employees" table.
It limits the result set to include only the first 10 rows using the LIMIT clause.
The result set will contain employee IDs and first names for the first 10 employees in the employees table, based on the default ordering of the table.

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       | 1987-06-17 | AD_PRES    | 24000.00 |           0.00 |          0 |   		  90 |
|         101 | Neena       | Kochhar     | NKOCHHAR | 515.123.4568       | 1987-06-18 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         102 | Lex         | De Haan     | LDEHAAN  | 515.123.4569       | 1987-06-19 | AD_VP      | 17000.00 |           0.00 |        100 |            90 |
|         103 | Alexander   | Hunold      | AHUNOLD  | 590.423.4567       | 1987-06-20 | IT_PROG    |  9000.00 |           0.00 |        102 |            60 |
|         104 | Bruce       | Ernst       | BERNST   | 590.423.4568       | 1987-06-21 | IT_PROG    |  6000.00 |           0.00 |        103 |            60 |
|         105 | David       | Austin      | DAUSTIN  | 590.423.4569       | 1987-06-22 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         106 | Valli       | Pataballa   | VPATABAL | 590.423.4560       | 1987-06-23 | IT_PROG    |  4800.00 |           0.00 |        103 |            60 |
|         107 | Diana       | Lorentz     | DLORENTZ | 590.423.5567       | 1987-06-24 | IT_PROG    |  4200.00 |           0.00 |        103 |            60 |
|         108 | Nancy       | Greenberg   | NGREENBE | 515.124.4569       | 1987-06-25 | FI_MGR     | 12000.00 |           0.00 |        101 |           100 |
..........
|         206 | William     | Gietz       | WGIETZ   | 515.123.8181       | 1987-10-01 | AC_ACCOUNT |  8300.00 |           0.00 |        205 |           110 |
+-------------+-------------+-------------+----------+--------------------+------------+------------+----------+----------------+------------+---------------+

View the table

Output:

pg_exercises=# SELECT employee_id, first_name
pg_exercises-# FROM employees  LIMIT 10;
 employee_id | first_name
-------------+------------
         100 | Steven
         101 | Neena
         102 | Lex
         103 | Alexander
         104 | Bruce
         105 | David
         106 | Valli
         107 | Diana
         108 | Nancy
         109 | Daniel
(10 rows)

Go to:

PREV : Write a query to check whether the first_name column of the employees table containing any number.
NEXT : Write a query to get a monthly salary (rounded up to 2 decimal places) of each employee.

Practice Online

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