Will the following query fetch all records from tab table?
Select * from tab where b='a'
UNION 
Select * from tab where b<>'a'
Explanation
NULL value is not covered by any of the queries.
SQL
SQL Quiz
Start Quiz

or Read more about SQL Quiz

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback