Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is DB Development software?

1996


Explain about relational operator join?

973


Explain the rollup operator?

988


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

947


What is dbms and its application?

939


To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

3939


Who are naive users?

947


How to use online Backups?

2145


I have a few records all are same structures data, I want to store data in multiple targets how

2583


What is the physical representation for a many-to-many relationship?

1009


Write short notes on manual refreshes.

2676


Write the fastest query to find out how many rows exist in a table?

1049


How is data stored in dbms?

881


What is database design and development?

950


Explain about the relational database?

991