Interested to Buy Any Domain ? << Click Here >> for more details...
What is a self join? Explain it with an example?
- 16 Answers
- 61208 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
How to generate OIDS
What is the physical representation for a many-to-many relationship?
Explain the role of indexing in databases?
What is database design and development?
How you can make a parameterized view?
Explain what a database is?
How to use timestamp datatypes
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
How long can an error message be in raiseerror function?
Write short notes on manual refreshes.
What is a database development?
Which data type cannot be used as a parameter in a udf?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
Why does this query return 0?
