Multiple choice

Which of the following is/are the main objective(s) of SQL SELECT statement?

  1. Projection, selection and joining

  2. Updating the data

  3. Inserting new data in the tables

  4. Deleting data from tables

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Projection is used to choose the columns in a table that you want, returned by your query. Selection is used to choose the rows in a table that you want, returned by a query. Joining is used to join different tables by creating logic between them.