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 procedures used for?
What are the advantages of sql? Explain
What is set serveroutput on?
What is union, minus and interact commands?
What does closing a cursor do?
What is the difference between a primary key and a clustered index?
What is plpgsql language?
What is pivot table in sql?
Is sql microsoft?
What is primary key secondary key alternate key candidate key?
What do you mean by field in sql?
how to run 'mysql' commands from a batch file? : Sql dba
how many tables will create when we create table, what are they? : Sql dba
Does a primary key have to be a number?
Why partition by is used in sql?
