Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous

 

 

 

 

What will happen if the subquery in the following SQL returns more than one value?

SELECT Name, Marks

FROM Student

WHERE Class = (SELECT Class FROM School  WHERE Class  ='II%')

 

1.      The outer query will run with the first value fetched from sub-query

2.      It will not run and give no error

3.      It will give error

4.      The outer query will run with last value fetched from sub-query

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.