What is the output of each statement in the below query:
[sql]
SELECT 1 WHERE NULL = NULL
SELECT COUNT(10)
SELECT COUNT(C1) FROM (SELECT ‘A’ AS C1 UNION ALL SELECT ‘B’ UNION ALL SELECT NULL) T
SELECT NULL
UNION
SELECT NULL
[/sql]
Please provide your comments.
i got answers like
1. no coloumn
2.1
3.2
4.NULL
i want explanation for dis queries .