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 inline command?

2 Answers  

What is sqlite format?

0 Answers  

HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  

Write a procedure to return the month and the number of developers joined in each month (cursor )

2 Answers   Tech Mahindra,

What is posting?

0 Answers  




What is a mutating table and a constraining table?

0 Answers  

What does trigger mean in psychology?

0 Answers  

What is bulk collect in pl sql?

0 Answers  

what is the different between unique+not null & primary key,

4 Answers  

What are aggregate functions in sql?

0 Answers  

What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,

How do you explain an index number?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories