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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

In which situation you use Self joins?

Question Posted / sundar


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

UPDATE statement can on a single table or on the multiple table?

7 Answers   iGate, TCS,

What is self join in sql server joins?

0 Answers  

Explain what is sql server english query?

0 Answers  

What are temporal tables in sql server 2016?

0 Answers  

When do you think a developer should use sql server-based cursors?

0 Answers  

What is the recovery model?

0 Answers  

Creating Tables Using SELECT

1 Answers  

When is the use of update_statistics command?

0 Answers  

Do comments need to go in a special place in sql server 2005?

0 Answers  

difference between sql server2000 and sql server2005

1 Answers   KPMG,

How to generate random numbers with the rand() function in ms sql server?

0 Answers  

what are defaults? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories