Tags
Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Learn complex SQL, Learn SQL, Learn T-SQL, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SQL, SQL 2012, SQL Challenge, SQL Challenges, SQL pl/sql puzzles, SQL Puzzles, SQL SERVER Interview questions, SQL SERVER2005/2008, SQL Sudoku, SQLSERVER, T SQL Puzzles, T-SQL Challenge, Tough SQL Challenges, Tough SQL Puzzles, TSQL, TSQL Challenge, TSQL Challenges, TSQL Interview questions, TSQL Queries
T–SQL 3.…<SQLServer 2008 R2>
Can you provide output for following queries
SELECT ‘NO I am not in T-SQL’ WHERE 1=1 HAVING 1=2
SELECT ‘Yes I am in T-SQL’ WHERE 1=2 HAVING 1=1
Note: –Please note that the above queries will work differently when used withTables
Keep
Learning