What is SELECT? Meaning and example

What is SELECT?

SELECT: The SQL statement that reads data. It names the columns or expressions to return, the table(s) to read from, and optional filters, grouping and ordering. It never changes stored data.

Level: beginnerTopic: SQL databases

SELECT: an example

SELECT name, price_inr FROM products; returns just those two columns for every product.

Related terms

FROM clause
WHERE
ORDER BY
GROUP BY

More SQL databases terms

Selectivity
Self join
Sharding
SQL
SQL injection
SQLite
Stored procedure
Subquery

Where you learn it

SELECT is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.