Subquery used in Where returns more than one row
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
“; ; ; ;