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 are the popular database management systems in the it industry?
Can we create a trigger on view?
What is rollback?
What is difference between cursor and trigger?
What is synchronized subquery?
How to assign sql query results to pl sql variables?
What is the difference between rename and alias?
How do you use join?
Why triggers are used?
What is mutating table error?
What is transaction control language (tcl)?
What is difference between stored function and application function?
What is a native sql query?
What is %s in sql?
Why truncate is faster than delete?
