Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
What is java sql package?
What is not in sql?
what is the difference between a web-garden and a web-farm? : Sql dba
How can we solve sql error: ora-00904: invalid identifier?
Write a query to display the current date in sql?
How do you update a sql procedure?
what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba
What is procedure explain with program?
What is partition by in sql?
Is foreign key mandatory?
what is the difference between join and union? : Sql dba
how to check server status with 'mysqladmin'? : Sql dba
What is data abstraction in sql?
What is structural independence and why is it important?
Can we insert in view in sql?
