Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / alok kumar samartha
The concept of joining a table with itself is called self
join or inner join.It works based on the provided join condition
example:-select e1.empno employee,e2.ename manager from emp
e1,emp e2 where e2.empno=e1.mgr;
| Is This Answer Correct ? | 3 Yes | 4 No |
Post New Answer View All Answers
What is difference between primary and secondary key?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
Does sql use python?
What are the types of triggers in sql?
Explain clause in sql?
What is difference between my sql and sql?
what is 'mysqldump'? : Sql dba
how can we submit a form without a submit button? : Sql dba
How do you update sql?
How do I run a script in sql developer?
Is sql a oracle?
What is a sql driver?
Explain table and field in sql?
What is difference between table and view?
What is procedure explain with example?
