What is SELECT?

Learn that SELECT pulls data from a table.

What is SELECT?

The SELECT statement retrieves data from a database. It lets you choose rows and columns from a table. It is the most fundamental SQL command and appears in almost every query.

A SELECT statement has at least two parts: SELECT says which columns you want, and FROM says which table to read. The result comes back as a table.

What is SELECT? — details

The simplest SELECT query looks like this:

SELECT name, price
FROM products;

Here the name and price columns are pulled from the products table. You separate column names with commas; no comma after the last column. A semicolon ends the statement. The result table follows the column order of the query and includes every row of the table.

Exercise What is SELECT?

Write a query that selects the name and price columns from the products table.

Show example solution

SELECT name, price
FROM products

Test yourself

Which statement reads data?
- SELECT
- DELETE
- INSERT
- DROP
Show answer

SELECT — SELECT is used to read data.

SELECT keyword

-- sorguyu tamamla
____ name, price
FROM products;

Show answer

-- sorguyu tamamla
SELECT name, price
FROM products;

What is SELECT: match the terms

SELECT

choose columns
FROM

specify table
WHERE

filter rows
ORDER BY

sort

Next lesson: Selecting all columns

We Are Enhancing Your Experience

Cookie Preferences

Strictly Necessary Cookies

Analytical Cookies