Which element belongs in the blank if you want to display data from all rows with a credit limit greater than the credit limit of one or more category B cardholders? WHERE (CREDIT_LIMIT _____ (SELECT CREDIT_LIMIT FROM CARDHOLDER WHERE CATEGORY = 'B'))
A) ANY
B) ALL
C) UNION
D) INTERSECT

Question

Which element belongs in the blank if you want to display data from all rows with a credit limit greater than the credit limit of one or more category B cardholders? WHERE (CREDIT_LIMIT > _____ (SELECT CREDIT_LIMIT FROM CARDHOLDER WHERE CATEGORY = 'B'))
A) ANY
B) ALL
C) UNION
D) INTERSECT

Quizplus · Accepted Answer

The correct SQL keyword to use in this context is "ANY". This is because "ANY" compares a value to each value in a list or returned by a subquery, and if the comparison is true for any one of those values, the overall expression is true. In this case, using "ANY" allows the query to return rows where the credit limit is greater than the credit limit of any one or more category B cardholders.

Which Element Belongs in the Blank If You Want to Display