This is one of the questions I have on my interview exam. It is a take home exam and I have not learned SQL but the employers want to know my know my skills to find answers using any means possible. Question: Review the following SQL code and give a brief explanation SELECT 'AD', B.AccountID,'Change' FROM (SELECT DISTINCT A.sAMAccountName As AccountID from (select AG.sAMAccountName...

ajith007

 Profile Answers by ajith007 Questions by ajith007

• Dec 6th, 2007

Use of distinct, not in keywords make this code altogether complicated. But what I discern from this code 'catch' lies in FULL OUTER JOIN since it retreives all the data including your null values.The union here returns the cross product of query mentioned that includes your null values.

Answer Question  Select Best Answer