Tags

, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,


T-SQL Output Query | [ The Single SELECT Puzzle List – Part 4 ]

Please go through the below objective type queries and provide output..


--


--Query 1
SELECT COUNT(NEWID())

--Query 2
SELECT 50 WHERE NULL = NULL

--Query 3
SELECT SUM(-1)

--Query 4
( SELECT 'A' AS C1 ) UNION  ( SELECT 'X' UNION ALL SELECT NULL UNION ALL SELECT NULL )

--Query 5
( SELECT 'A' AS C1 ) UNION  SELECT 'X' UNION ALL SELECT NULL UNION ALL SELECT NULL 

--Query 6 
SELECT COUNT(100)
 
--Query 7
SELECT COUNT(C1) FROM (SELECT 'X' AS C1 UNION ALL SELECT 'Y' UNION ALL SELECT NULL) T
 
--Query 8
SELECT NULL
UNION
SELECT NULL

--Query 9
SELECT COUNT(*) OVER ()


--

Keep Learning

MSBISKILLS.Com

Pawan Kumar Khowal

Advertisements