|
| Home | Tech FAQ | Interview Questions | Placement Papers | Tech Articles | Learn | Freelance Projects | Online Testing | Geeks Talk | Job Postings | Knowledge Base | Site Search | Add/Ask Question |
 Related Questions There are 2 tables, Employee and Department. There are few records in employee table, for which, the There are 2 tables, Employee and Department. There are few records in employee table, for which, the department is not assigned. The output of the query should contain all th employees names and their corresponding departments, if the department is assigned otherwise employee names and null value in the place department name. What is the query? Select emp_name, Dept_name from (Employee_table left outer join Dept_table on Employee_table.Dept_id = Dept_table.Dept_id) Read Answers (7) | Asked by : Bindu Puvvala When using a count(distinct) is it better to use a self-join or temp table to find redundant data, and provide an example? Read Answers (1) | Asked by : KP Latest Answer : Theta joins are those joins that use any of the comparison operators(i.e. less than,less than or equal to,greater than,greater than or equal to) ... Read Answers (1) | Asked by : Ashish Sharma Tags : DBMS 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: Latest Answer : 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 ... Why IN query not worked in inner join? Latest Answer : Inner Join is nothing but self join. In self join the system wil take one record from tabel (i.e. first objective) and compare with the same table but objective is different.so at a time your comparing one record of one table to another record of another ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
