Sign Up Login


  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

Define union, minus, union all, intersect ?

0 Answers  

How to download oracle sql developer?

0 Answers  

how many values can the set function of mysql take? : Sql dba

0 Answers  

What is clause?

0 Answers  

Wat is SGA ?

3 Answers   ABB,




How do you update a table in sql?

0 Answers  

what is sub-query? : Transact sql

0 Answers  

What is meant by <> in sql?

0 Answers  

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

Why is normalization important?

0 Answers  

What are the query optimization techniques?

0 Answers  

Where is sql database stored?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories