What is a self join? Explain it with an example?
Answer Posted / dhivya
lets take a table A which is joined to itself with its
alias is said to be self join.Most familiar example is
finding the manager of the employee..
select e1.emp_id manager_id,e2.emp_id employee_id from
employee e1,employee e2
where e1.emp_id=e2.emp_id
| Is This Answer Correct ? | 66 Yes | 37 No |
Post New Answer View All Answers
What are the types of database model?
What is a database development?
How to replace not in with not exist?
What is DB Development software?
Write short notes on manual refreshes.
What is data modeling with example?
On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?
Who are naive users?
Explain about relational operator join?
I have a few records all are same structures data, I want to store data in multiple targets how
What is database design and development?
Explain about query and reporting.
Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in
How to customize error conditions.
Which four data types cannot be used as a return type from a user-defined function?