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

What do you mean by normalisation?

0 Answers  

Can two tables share the same primary key?

0 Answers  

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

0 Answers  

What is the use of floor function in sql server?

0 Answers  

How to create a trigger for insert only?

0 Answers  




how to give input dynamically to a insert statement in sqlserver

3 Answers   HCL,

how to dispaly a particular row details from a given table

2 Answers  

what is an sql server?

1 Answers  

Which are ddl commands?

0 Answers  

Define model database?

0 Answers  

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?

4 Answers   IBM,

how to get rank of diffrent student in same table based on newly inserted row in sql server2008

4 Answers   ABC,

For more SQL Server Interview Questions Click Here
Categories