What is a self join? Explain it with an example?
Answer Posted / ganesh
A join joins with itself is called self join
Working with self joins we use Alias tables
| Is This Answer Correct ? | 96 Yes | 21 No |
Post New Answer View All Answers
What is DB Development software?
Explain about relational operator join?
Explain the rollup operator?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What is dbms and its application?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
Who are naive users?
How to use online Backups?
I have a few records all are same structures data, I want to store data in multiple targets how
What is the physical representation for a many-to-many relationship?
Write short notes on manual refreshes.
Write the fastest query to find out how many rows exist in a table?
How is data stored in dbms?
What is database design and development?
Explain about the relational database?