Multiple choice technology databases

What does the SQL FROM clause do?

  1. Specifies data retrieved

  2. Specifies the tables to retrieve rows from.

  3. Specifies the columns we are retrieving.

  4. Specifies a search condition.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The SQL FROM clause specifies which table(s) to retrieve data from. It's a mandatory clause in most SELECT queries and identifies the source of the data. The SELECT clause (not FROM) specifies which columns to retrieve. The WHERE clause specifies search conditions, not FROM.

Keep practicing — related questions