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 does cross join work in sql?
Is microsoft sql free?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
Does mysql_real_escape_string prevent sql injection?
What is having clause in sql?
what is a trigger in mysql? : Sql dba
How global cursor can be declare with dynamic trigger ?
how to convert numeric values to character strings? : Sql dba
Do we need commit after truncate?
Is id a reserved word in sql?
what are enums used for in mysql? : Sql dba
How do you write an inner join query?
what is 'mysqldump'? : Sql dba
Show how functions and procedures are called in a pl/sql block.
How many types of tables are there?
