Daily Archives: April 3, 2015

T-SQL Output Query | [ The JOIN Puzzle – Part 3 ]

03 Friday Apr 2015

Posted by in SQL SERVER, T SQL Puzzles, Tricky SQL Queries

≈ Leave a comment

Tags

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


T-SQL Output Query | [ The JOIN Puzzle – Part 3 ]

–Let’s say we have 2 table TestJoins3 and TestJoins4. Both the tables having only one ID column. Here you have to provide the output of the queries given below. Before that please go through the input data below.

5

6


--

--Query 1
SELECT t1.ID , t2.ID FROM [dbo].[TestJoins3] t1 INNER JOIN [dbo].[TestJoins4] t2  ON t1.ID = t2.ID

--Query 2
SELECT t1.ID , t2.ID FROM [dbo].[TestJoins3] t1 LEFT OUTER JOIN [dbo].[TestJoins4] t2  ON t1.ID = t2.ID

--Query 3
SELECT t1.ID , t2.ID FROM [dbo].[TestJoins3] t1 RIGHT OUTER JOIN [dbo].[TestJoins4] t2  ON t1.ID = t2.ID

--Query 4
SELECT t1.ID , t2.ID FROM [dbo].[TestJoins3] t1 FULL OUTER JOIN [dbo].[TestJoins4] t2  ON t1.ID = t2.ID

--

Please leave a comment if you need solution to the above puzzle

Keep Learning

T-SQL Output Query | [ The JOIN Puzzle – Part 2 ]

03 Friday Apr 2015

Posted by in SQL SERVER, T SQL Puzzles, Tricky SQL Queries

≈ Leave a comment

Tags

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


T-SQL Output Query | [ The JOIN Puzzle – Part 2 ]

–Let’s say we have 2 table TestJoins1 and TestJoins2. Both the tables having only one ID column.Here you have to provide the output of the queries given below. All the queries are using different types of joins.

3

4


--

--Query 1
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoins1] t1 INNER JOIN [dbo].[TestJoins2] t2  ON t1.ID = t2.ID

--Query 2
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoins1] t1 LEFT OUTER JOIN [dbo].[TestJoins2] t2  ON t1.ID = t2.ID

--Query 3
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoins1] t1 RIGHT OUTER JOIN [dbo].[TestJoins2] t2  ON t1.ID = t2.ID

--Query 4
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoins1] t1 FULL OUTER JOIN [dbo].[TestJoins2] t2  ON t1.ID = t2.ID

--

Please leave a comment if you need solution to the above puzzle

Keep Learning

T-SQL Output Query | [ The JOIN Interview Question – Part 1 ]

03 Friday Apr 2015

Posted by in SQL Concepts, SQL SERVER, T SQL Puzzles, Tricky SQL Queries

≈ 2 Comments

Tags

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


T-SQL Output Query | [ The JOIN Puzzle – Part 1 ]

Please go through the queries and the sample input data and provide the outputs of the query given below.

–Let’s say we have 2 table TestJoinsT1 and TestJoinsT2. Both the tables having only one ID column. Here you have to provide the output of the queries given below

1

2


--Please go through the data given above and provide outputs for below queries

--Query 1
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoinsT1] t1 INNER JOIN [dbo].[TestJoinsT2] t2 
ON t1.ID = t2.ID

--Query 2
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoinsT1] t1 LEFT OUTER JOIN [dbo].[TestJoinsT2] t2 
ON t1.ID = t2.ID

--Query 3
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoinsT1] t1 RIGHT OUTER JOIN [dbo].[TestJoinsT2] t2 
ON t1.ID = t2.ID

--Query 4
SELECT t1.ID , t2.ID
FROM [dbo].[TestJoinsT1] t1 FULL OUTER JOIN [dbo].[TestJoinsT2] t2 
ON t1.ID = t2.ID

Please leave a comment if you need solution to the above puzzle

Keep Learning