Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / ram
Normally we joins for retrieve data from more than 1 table
In some cases we need to join 1 table itself to join itself
condition is table having two column with same data type &
size but name are different
In emp table empno & mgrno are two columns example for this
select ename,job,sal,e.empno,m.mgrno from emp e inner join
emp m on m.mgrno=e.empno
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How do we use distinct statement? What is its use?
What is record type in pl sql?
What is the difference between the repeatable read and serializable isolation levels? : Transact sql
Can we use update in sql function?
What is consistency?
What are the qualities of 2nf?
What is output spooling in sql*plus?
What is sql and also describe types of sql statements?
What is pl/sql table? Why it is used?
Can we use distinct and group by together?
Can a varchar be a primary key?
How to get unique records from a table?
What is mutating trigger?
Is it possible for a table to have more than one foreign key?
What is trigger explain it?
