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
how to create a new view in mysql? : Sql dba
what is clause? : Sql dba
What is an ndf file?
What is asqueryable?
What is java sql driver?
What does select count (*) mean in sql?
What is fmtonly in sql?
How do I edit a trigger in sql developer?
Why are aggregate functions called so?
Can a commit statement be executed as part of a trigger?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
What is sequence in sql?
What is %rowtype in pl sql?
Can 2 queries be executed simultaneously in a distributed database system?
What is the advantage of nosql?