JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TAB

Explain SELF JOIN ?

Question Posted / sandhya

Answer Posted / sandhya

JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TABLE WITH DIFFERENT ALIYAS'S.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are different types of table joins?

555

What stored by the master?

537

What number sorts of privileges are accessible in sql?

593

How would you go about developing a ssrs report?

110

How to modify an existing stored procedure in ms sql server?

521

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3749

What is SQL Azure Federations?

Can you explain what is the use of custom fields in report?

597

How do indexes help, types?

546

How to replace given values with null using nullif()?

570

How to modify the underlying query of an existing view?

530

What is use of attribute hierarchy optimized state? : sql server analysis services, ssas

580

What is rank function?

601

Why can there be only one clustered index and not more than one?

543

What is an index in sql?

544