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 / mona

A table join to itself is known as self join.

select emp.ename,mngr.ename from emp.empl,emp.mngr where
emp.mngrno=mngr.empno

Is This Answer Correct ?    15 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the role of indexing in databases?

1120


Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2201


What are the types of database model?

1077


Why does this query return 0?

1010


What is the database development process?

1211


How to use online Backups?

2196


What are the three types of database design?

1019


What are the key features of dbms?

983


Explain about the hierarchical model of the database?

1106


Explain about network model?

996


Write short notes on manual refreshes.

2725


What are the main phases of database development?

974


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

2641


How to read and create .LDC data files which are used by linguatic dictionary.

2527


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?

993