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 posed to me at a job interview.

My enquiry is from Subqueries in chapter Manipulating Data with Select of SQL Server

Answer 1

Correct choice is (a) Where, from

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