SQL SELECT Exercises

Practice choosing columns, filtering rows, sorting results, and building reliable SQL foundations. These 2 interactive challenges use real schemas and instant query validation.

Beginner Intermediate Advanced JOINs GROUP BY Window functions

2 SQL challenges

Open Practice Arena

SELECT

Beginner

Select All Employees

Write a query to select all columns from the employees table. Return columns: id, first_name, last_name, email, department_id, salary, hire_date, manager_id.

10 XPSolve challenge

SELECT

Beginner

Select Employee Names

Write a query to retrieve only the first_name and last_name of all employees. Return columns: first_name, last_name.

10 XPSolve challenge

Concept guide

How to practice SQL SELECT

SELECT chooses the columns and expressions returned by a query. Start by identifying the source table and the requested output, then check column names, aliases and row ordering.

What to master

• Choose only the columns required by the task
• Use aliases to label calculated or renamed output columns
• Distinguish selecting columns from filtering rows
• Use ORDER BY when a deterministic result order is required

A reliable problem-solving workflow

1Read the task and identify the source table.
2List the requested columns in the required order.
3Add any requested expressions, aliases or row filters.
4Run the query and check the output columns and ordering.

Does SELECT guarantee the order of rows?

No. Use an explicit ORDER BY when the task requires rows in a particular order.

Should I always select every column?

No. Selecting named columns makes the output explicit. Return every column only when the task asks for it.