In which situation you use Self joins?
- 1 Answers
- 6996 Views
- CarrizalSoft Technologies, HP, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How do you run a trace?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
Explain different forms of normalization?
What are the different sql server versions?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What is difference between unique and primary key?
How to set database to be read_only in ms sql server?
Can another user execute your local temporary stored procedures?
How to get the definition of a trigger back?
Explain external key management in sql server 2008
What is an active database?
what information is maintained within the msdb database? : Sql server administration
What is wide table?
Can sql server 2016 run on windows 7?
Explain about unique identifier data type in sql server?
