Skip to Content
Custom Search

Reply to comment






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


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

    More information about formatting options

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


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


Share this if you liked it!



Number of Registered users 714
Theme by Dr. Radut.