what is self join and why is it required? : Sql dba



what is self join and why is it required? : Sql dba..

Answer / suresh pagadala

Self join is nothing but the table performs join condition itself same table is called self join

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

What are types of exception?

0 Answers  


what are the drivers in mysql? : Sql dba

0 Answers  


Give the structure of the function ?

2 Answers  


Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,






How can a pl sql block be executed?

0 Answers  


What are the blocks in stored procedure?

6 Answers   Microsoft,


what is 'mysqld'? : Sql dba

0 Answers  


How can we schedule the procedure to run automatically ?

3 Answers  


Is sql better than excel?

0 Answers  


What is duration in sql profiler trace?

0 Answers  


Why do we create views in sql?

0 Answers  


Categories