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...


In which situation you use Self joins?



In which situation you use Self joins?..

Answer / arun anoop m

We use Self Join, if we have a table that references itself.


For example, In the Employee Table below MANAGERID column
references EMPLOYEEID column. So the table is said to
referencing itself.This is the right scenario where we can
use Self Join.

Is This Answer Correct ?    8 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is it ok to shrink transaction log?

0 Answers  


How much memory that we are using in Logshipping Concept?

0 Answers  


What is stretch database in sql server?

0 Answers  


Can we use max in where clause?

0 Answers  


What is a Join and explain its types?

0 Answers  


Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  


What is the stuff?

0 Answers  


What is the difference between cartesian product and cross join?

0 Answers  


What are cursors and when they are useful?

0 Answers  


Difeerence between ssis 2005 and ssis2008?

1 Answers   Convergys,


write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,


What are examples of triggers?

0 Answers  


Categories