In which situation you use Self joins?
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
What are the advantages of sql stored procedure?
What are different types of roles provided by ssrs?
What are the advantages of paper records?
What are the instances when triggers are appropriate?
How to generate create procedure script on an existing stored procedure?
How do I make a resultset scrollable?
Do you know what is xpath?
Explain security with sql azure?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
What is query processing?
How to create a new schema in a database?
What is a synonym for manipulation?
What types of replication are supported in sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is correlated subquery in sql server?