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
Show how functions and procedures are called in a pl/sql block.
How do I pipe the output of one isql to another?
What are the different types of dbms?
What is data definition language?
Explain architecture of sql server notification services?
Is sql dba a good career? : SQL DBA
What are the disadvantages of file system?
How do I run a query in pl sql developer?
What is cursor and its types?
What is the difference between delete and truncate statement in sql?
How do I create a sql script?
Is crud a cuss word?
What is a sql statement?
What are sql data types?
what is the difference between ereg_replace() and eregi_replace()? : Sql dba
