COMPLEX / DIFFICULT SQL QUERIES EXAMPLES FOR INTERVIEW SET-8.4

Here we again come with the hard/tricky sql server interview queries examples for sql server Interview preparations. Following is query is based on sql joins, these query will improve your join concept, and you can evaluate yourself by answering these queries.
So first try to answer every query without see the answer, then compare the answers.

If you have not read our previous set of complex sql interview queries then first go through following link, Click here for read previous set of queries

HARD/TRICKY/COMPLEX SQL JOIN QUERIES EXAMPLES

104) . What would be the out-put of the following Sql query?

SELECT A.A FROM (SELECT 1 A, 2 B) A

JOIN (SELECT 1 A,1 B)B ON A.A = B.B

Options:

105). What would be the out-put of the following Sql query?

SELECT B.A FROM (SELECT 1 A) A

JOIN (SELECT 1 A, 2 B)B ON A.A = B.A

Options:

106). What would be the out-put of the following Sql query?

SELECT B.A FROM (SELECT 1 A) A

JOIN (SELECT 1 A, 2 B)B ON A.A = B.B

Options:

107). What would be the out-put of the following Sql query?

SELECT * FROM (SELECT 1 A UNION ALL SELECT 2 B) A

JOIN (SELECT 1 A,2 B UNION ALL SELECT 1 A, 1 B)B ON A.A = B.B

Options:

108). What would be the out-put of the following Sql query?

SELECT * FROM (SELECT 1 A UNION ALL SELECT 2 B) A

JOIN (SELECT 1 A,2 B)B ON A.A = B.B

Options:

Click here for read previous set of queries

Answers: 104) C, 105) C, 106) B, 107) E, 108) D

COMPLEX / DIFFICULT SQL QUERIES EXAMPLES FOR INTERVIEW SET-8.4

Comments

Search This Blog

Featured Post

You may like it

Contact Form