By admin | August 11, 2009

SAS Certified Adv Programmer 50 Questions (7)

How many columns can an SQL procedure subquery within a WHERE or HAVING clause return to the outer query?

a. 0
b. 1
c. 2
d. the same number of columns that are in the table

3 comments | Add One

  1. admin - 08/11/2009 at 3:17 pm

    B

  2. chinawokee - 07/10/2014 at 2:30 pm

    ?
    for exists…like problem 6

    does it mean it combines multiple columns into one?

  3. Chen - 02/4/2015 at 12:48 pm

    “A subquery in the WHERE or HAVING clause can return values for multiple rows but only for a single column.”

Leave a Comment

Leave a Reply

Your email address will not be published.