1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

In which situation you use Self joins?

Question Posted / sundar


In which situation you use Self joins?..

Answer / arun anoop m

We use Self Join, if we have a table that references itself.


For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Explain transaction server auto commit?

0 Answers  

What is nolock hint in sql server 2008

0 Answers   HCL,

What is Inner Join?

2 Answers  

what type of indexes physically sort data?

3 Answers  

What is the difference between indexing and hashing?

0 Answers  




What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

What is the use of DBCC commands?

4 Answers   NA,

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

How to encrypt Strored Procedure in SQL SERVER?

0 Answers  

System requirements for sql server 2005 express edition?

0 Answers  

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

diffrence between Cluster Index and non Cluster Index

3 Answers   Wipro,

For more SQL Server Interview Questions Click Here
Categories