clause is an additional filter that is applied to the result.

Related MCQs

• ……………… clause is an additional filter that is applied to the result.
• The              clause allows us to select only those rows in the result relation of the           clause that satisfy a specified predicate.
• The                  clause is used to list the attributes desired in the result of a query.
• The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is               false and unknown is            while unknown and unknown is            
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• A type of query that is placed within a WHERE or HAVING clause of another query is called
• Using the              clause retains only one copy of such identical tuples.
• The          connective tests for set membership, where the set is a collection of values produced by a select clause. The           connective tests for the absence of set membership.
• SQL applies predicates in the                 clause after groups have been formed, so aggregate functions may be used.
• The                  keyword is used to access attributes of preceding tables or subqueries in the from clause.