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 8
—Input
—————–
ID |
1 |
2 |
3 |
4 |
5 |
CREATE TABLE List ( ID INT )
GO
INSERT INTO List(ID) VALUES (1),(2),(3),(4),(5)
SELECT * FROM List
—Find out the OUTPUT of the following query
SELECT L.ID List1 , L1.ID List2 FROM List L JOIN List L1 ON L.ID <> L1.ID
Output would be
List1 | List2 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
1 | 2 |
3 | 2 |
4 | 2 |
5 | 2 |
1 | 3 |
2 | 3 |
4 | 3 |
5 | 3 |
1 | 4 |
2 | 4 |
3 | 4 |
5 | 4 |
1 | 5 |
2 | 5 |
3 | 5 |
4 | 5 |
Keep Learning.
Pawan Kumar