Tags
Complex SQL Challenges, complex sql statement(puzzle), Complex TSQL Challenge, Divide rows into two columns, Interesting Interview Questions, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Khowal, last non null puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, Pawan, Pawan Khowal, Pawan Kumar, Pawan Kumar Khowal, PL/SQL Challenges, Prev Value puzzle, Previous value puzzle, puzzle sql developer, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Interview Questions, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL Quiz, SQL Server Database, SQL SERVER Interview questions, SQL Skills, SQL Sudoku, SQL Top clause, SQL Trikcy question, sql/database interview for puzzle sql developer, SQLSERVER, T SQL Puzzles, T-SQL Challenge, TOP Clause, Tough SQL Challenges, Tough SQL Puzzles, Tricky output puzzles, Tricky Questions, Tricky SQL, Tricky SQL outputs, Tricky SQL Q's, Tricky SQL Questions, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries, Week puzzle
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
Improving my SQL BI Skills 