The SELECT Statement: an overview

A SELECT statement, or query, asks the database a question and returns the rows and columns that answer it.

Novice · SQL · MySQL · Updated

By

We will begin by learning how to retrieve data from a database. The SELECT statement is also known as a query. This is because we are querying (requesting) data from a database. You can think of a SELECT query as a way of asking questions of a database.

It helps to think of each query as though you are creating a report, the query is the way to get access and format data.

Cheat sheets