Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 60487 Views
- TCS, I also Faced
- E-Mail Answers
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
State the acid rules?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
Explain about the relational database?
Who are end users in dbms?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
How to use online Backups?
Write the fastest query to find out how many rows exist in a table?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Write short notes on manual refreshes.
What are the three basic rules which are to be followed for the relational model of the database?
What is a database development?
In which database can extended stored procedures be added?
You are testing the performance of a query the first time you run the query, the performance is slow. the second time you run the query, the performance is fast. why is this?
Where is dbms used?
I have a few records all are same structures data, I want to store data in multiple targets how
