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
Explain the rollup operator?
explain detail about ftp in datastage?
What are the 18 schemas?
What is a database development?
Explain the role of indexing in databases?
Can an extended stored procedure be called from inside a user-defined function?
Who are naive users?
Explain about the database management systems.
What is database design and development?
What are the three basic rules which are to be followed for the relational model of the database?
How to replace not in with not exist?
What is normalization? Explain different levels of normalization?
Explain what a database is?
How can I detect whether a given connection is blocked?
Explain about relational database management systems?