what is self join and how it works??

Question Posted / rk.nag

2 Answers
8440 Views
Infosys, I also Faced
E-Mail Answers

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

package specification-3 procedures package body-2 procedures will is execute

2 Answers PWC,

How do you declare a constant?

0 Answers

What does stand for in sql?

0 Answers

mail-id table contains two columns(email_id,userid) it contains different types of mail-ids,and no of users. here username length is differ na,(ex- tamil@yahoo.com,joshua@hotmail.com like) now i want to fetch the email-ids only starting from '@' (ex-@gmail.com,@yahoo.com,@hotmail.com

5 Answers

What is the difference between a database and a relational database?

0 Answers

What is the first action to perform a query? Suppose I have four tables and five joins and my query is getting slow day by day.

4 Answers Hexaware,

What is the difference between left join and right join?

0 Answers

What does an inner join do?

0 Answers

what is 'mysqldump'? : Sql dba

0 Answers

how is myisam table stored? : Sql dba