1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is self join and how it works??

Question Posted / rk.nag

Answers were Sorted based on User's Feedback



what is self join and how it works??..

Answer / 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

what is self join and how it works??..

Answer / alok kumar samartha

The concept of joining a table with itself is called self
join or inner join.It works based on the provided join condition
example:-select e1.empno employee,e2.ename manager from emp
e1,emp e2 where e2.empno=e1.mgr;

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is function and procedure?

0 Answers  

What is string data type in sql?

0 Answers  

What is graph sql?

0 Answers  

What is the difference between subquery and correlated query?

0 Answers  

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,




From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

How is a PL/SQL code compiled?

0 Answers  

What are the two parts of design view?

0 Answers  

What are the different dcl commands in sql?

0 Answers  

What is faster join or subquery?

0 Answers  

what are aggregate and scalar functions? : Sql dba

0 Answers  

What is number function in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories