capabilities of sql select statements 1

capabilities of sql select statements

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

Here is what the above code is Doing:
1. Selecting the columns in the table that are returned by the query
2. Selecting the rows in the table that are returned by the query
3. Bringing together data that is stored in different tables by specifying the link between them

Similar Posts