what is self join and how it works??

Answer Posted / srinu

Joining the Table data it self is called self join,it will work based on the join condition

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Are there any features that are decommissioned in 11g that are not present in 11g?

1819


What is sqlca in powerbuilder?

745


Is progress software supports to ( pl/sql )?

717


Does pl sql work in mysql?

687


Difference between truncate, delete and drop commands?

730






What does a pl/sql package consist of?

719


What are local and global variables and their differences?

806


Why use subqueries instead of joins?

795


How to write html code in pl sql?

800


How do you break a loop in pl sql?

726


What is an invalid partition table?

748


how to drop an existing index in mysql? : Sql dba

714


What is sql profiling in oracle?

737


What is indexes?

752


What are the different sql languages?

738