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 the use of index in sql?
What are data types in pl sql?
What is a data definition language?
what is cross join? : Sql dba
What are basic techniques of indexing?
What are the types of records?
What is nested table in pl sql?
Is hadoop a nosql?
How do I run sql profiler?
Can instead of triggers be used to fire once for each statement on a view?
How can we store rows in PL/SQL using array?
How do you explain an index number?
What is sql used for?
How do I tune a sql query?
What is bulk collect in pl sql?
