Reply to comment
What will happen if the subquery in the following SQL returns more than one value?
SELECT Name, Marks
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
Click the +1 button below to share it with your friends and colleagues
Share this if you liked it!