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

How much does a sql dba make? : SQL DBA

0 Answers  

What does select top 1 do in sql?

0 Answers  

how to Update table Sales_summary with max(sales) data from table sales_dataTable 1. sales_data table Table 2. Sales_summary Region sales Region sales N 500 N 0 N 800 W 0 N 600 W 899 W 458 W 900 I want the Sales_summary After Update like this Region Sales N 800 W 900

8 Answers  

Enlist the characteristics of pl/sql?

0 Answers  

what is denormalization. : Sql dba

0 Answers  




how tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

Explain about various levels of constraint.

0 Answers  

how to extract a unit value from a date and time? : Sql dba

0 Answers  

Explain alias in sql?

0 Answers  

Is record in pl sql?

0 Answers  

explain the delete statements in sql

0 Answers  

What are pl sql data types?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories