ACE TEST

Question

SELECT * FROM TABLENAME WHERE column_name = (SUBQUERY which returns same data types as column_name);

 

Is this query erroneous bcoz of an equal operator?

Answer 1

Yes! Equal sign is used to compare a single value. For this type of check, IN has to be used.