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 can you fetch first 5 characters of the string?
How do you optimize a query?
How can we optimize a sql query?
How do I make sql search faster?
How do I run a program in pl sql?
How to return multiple rows from the stored procedure?
What is memory optimized?
What is crud stand for?
Which is better cte or subquery?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
How exception is different from error?
How many triggers can be applied on a table?
what is 'trigger' in sql? : Sql dba
Why sql query is slow?
What is sql*plus?
