Interested to Buy Any Domain ? << Click Here >> for more details...
In which situation you use Self joins?
- 1 Answers
- 7537 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 happens if you add a new index to large table?
Can primary key be a foreign key?
What is the ‘fillfactor’?
Can group functions be used in the order by clause in ms sql server?
How do I find the port number for sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What are the types of indexing?
Can you explain what is the use of custom fields in report?
What is sub-query in sql server?
what is a correlated sub-query? : Sql server database administration
What are Spatial data types in SQL Server 2008
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
How to Insert multiple rows with a single insert statement?
What is the importance of a recovery model?
In what three ways is the return statement used in a stored procedure?
