Tags
Complex SQL Challenges, Complex TSQL Challenge, Interview Qs.SQL SERVER Questions, Interview questions on Joins, Interview Questions on SQL, InterviewQuestions, InterviewQuestions for SQL, Joins, Joins Interview questions, Joins Puzzle, Learn complex SQL, Learn SQL, Learn T-SQL, Objective Puzzle, PL/SQL Challenges, Puzzles, Queries for SQL Interview, SELECT Puzzle, SQL, SQL 2012, SQL 2014, SQL 2014 Interview Questions, SQL Challenge, SQL Challenges, SQL Joins, SQL pl/sql puzzles, SQL Puzzles, SQL Queries, SQL SERVER Interview questions, SQL Skills, 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
Please go through the below objective type queries and provide output..
-- --Query 1 SELECT (SELECT '1') --Query 2 SELECT SELECT '1' --Query 3 SELECT * FROM 'Emp' --Assume that Emp is the table present in the DB --Query 4 SELECT * FROM amit1 , amit2 --Query 5 SELECT COUNT(1) + COUNT(1) --Query 6 SELECT '12' FROM amit1 --Query 7 SELECT SUM(2+2*9) --Query 8 SELECT MAX(2+2*9) --Query 9 SELECT SUM(1,3,4) --Query 10 SELECT MAX('Pawan') --Query 11 Select Count(SELECT age FROM amit1) --