Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7447 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 does this statement do @@rowcount?
What is the optimization being performed in oracle and SQL Server?
How to verify a login name with sqlcmd tool?
What are orphan records?
List out the differences between the clustered index and non-clustered index in sql server?
What is simple indexing method?
Do you know what is similarity and difference between truncate and delete in sql?
Do you know what is normalization of database? What are its benefits?
How can we determine what objects a user-defined function depends upon?
What is difference between stored procedure and user defined function?
Explain the difference between control flow and data flow?
What is change data capture (cdc) feature?
What is single-user mode?
How many types of schemas are there?
what are the different ways to return the rowcount of a table?
