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
Explain about relational database management systems?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What are the 18 schemas?
Explain about the database management systems.
fact table and dimension table containg one to many relationship or many to one relastionship
How to use timestamp datatypes
What is the physical representation for a many-to-many relationship?
How to combine two function together?
Explain the process of the user request and data generating?
How would you design a database for an online site, which would average a million hits a day?
Explain about normal forms?
What is dbms and its application?
Explain the rollup operator?
To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?
How is data stored in dbms?