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
What is the difference between functions, procedures, and packages in pl/sql?
State some properties of relational databases?
What are the types of views in sql?
What are the different types of joins in sql?
How do I clear the screen in sql plus?
What is an exception in pl/sql?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is varray in pl sql?
What is structural independence and why is it important?
What does fetching a cursor do?
What is the difference between count 1 and count (*) in a sql query?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
Can a primary key be a foreign key?
What is the plv (pl/vision) package offers?
Why should I use postgresql?
