Question

The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.

(a) Where, from

(b) From, select

(c) Select, from

(d) From, where

The question was asked in homework.

My question is taken from SQL Queries topic in portion SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right answer is (a) Where, from

Explanation: Where selects the rows on a particular condition. From gives the relation which involves the operation.