select clause in sql code example

Example 1: select query in sql

SELECT column_name FROM table_name;

Example 2: sql select statement

Projection = Select the columns in
a table that are returned by a query
Selection = Selects the rows in a
table that are returned by a query
Join = Brings together data that is 
stored in different tables by
specifying the link between them