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
Can we rollback delete command?
How many sql commands are there?
What is the starting oracle error number?
How does sql store data?
Does postgresql run on the cloud?
What is graph sql?
Explain what is a subquery ?
what is a table in a database ? : Sql dba
What are the types of dbms?
what is csv? : Sql dba
Is left join faster than inner join?
What is pragma in sql?
How many types of tables are there?
How do I kill a query in postgresql?
What is dynamic query?
