Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7610 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
What is a self join in sql server?
What is the use of nvl work?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to query multiple tables jointly?
How does recursive cte works in sql server?
How do you rename a table in sql server?
What are .mdf files?
What are window functions in sql server?
How to find the login name linked to a given user name?
What is difference between join and natural join?
can we have a nested transaction? : Sql server database administration
What is the difference between dataadapter and datareader?
What are the kinds of subquery?
how will add additional conditions in sql?
What do you mean by SQL injection attack?
