Select

Select — Statement in SQL is used to query and retrieve data from a database. 

SELECT column1, column2, ...
FROM table_name;
SELECT: Specifies the columns to retrieve.
Column1, column2, ...: Lists the columns to be selected.
FROM: Specifies the table from which to retrieve the data.
Table_name: The name of the table.

Aliases

Aliases — Are used to give a table or a column in a table a temporary name. This name is often used to make the column or table names more readable or to simplify queries, especially when dealing with complex queries involving multiple tables and columns.

Related concepts

→
Select
→

Select — Structure map

Clickable & Draggable!

Select — Related pages:

SQL Aliases

SQL Introduction

SQL Joins

SQL Where

SQL Create

SQL Insert