Subquery used in Where returns more than one row

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

“; ; ; ;