Sign Up Login


  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

How do I know if localdb is running?

0 Answers  

Do you know what is rank function?

0 Answers  

What is query optimizer in sql server?

0 Answers  

How do I create a stored procedure in dbml?

0 Answers  

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  




what is the difference between count(*) and count(1) ?

0 Answers   MCN Solutions,

What will happen when a Rollback statement is executed inside a trigger?

1 Answers   Flextronics, Hexaware,

What is an indice?

0 Answers  

How many triggers you can have on a table?

0 Answers  

What are views used for?

0 Answers  

What is the difference between ddl and dml?

0 Answers  

what is statistics

1 Answers  

For more SQL Server Interview Questions Click Here
Categories