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

What are tuples in sql?

562


What are the ways on commenting in a pl/sql code?

511


What is procedure function?

537


Does a user_objects view have an entry for a trigger?

570


Are subqueries faster than joins?

573






what are the differences between require and include, include_once and require_once? : Sql dba

525


What is assignment operator in pl sql?

562


How to get list of all tables from a database?

623


What does count (*) mean?

523


what is row? : Sql dba

705


what are the types of join and explain each? : Sql dba

530


What is sql in java?

543


What is primary key and foreign key?

531


What is normalization in a database?

612


Is it possible to create the following trigger: before or after update trigger for each row?

718