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

display null value rows with out using null function?

8 Answers   Infosys,

Does sql view stored data?

0 Answers  

What is the difference between row level and statement level trigger?

0 Answers  

what are the advantages of cursors than procedures?

2 Answers  

how to include comments in sql statements? : Sql dba

0 Answers  




Can we use loop in sql?

0 Answers  

How many sectors are in a partition?

0 Answers  

what is user defined functions? : Sql dba

0 Answers  

What is compilation error in pl sql?

0 Answers  

What is a unique key?

0 Answers  

What is an exception in pl/sql?

0 Answers  

Which command is used to delete a package?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories