Self join is just like any other join, except that two instances of the sam

Explain SELF JOIN ?

Question Posted / dinesh rathod

Answer Posted / dinesh rathod

Self join is just like any other join, except that two instances of the same table will be joined in the query

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How to search for a string in all stored procedure in sql server?

990

Can you force a query to use a specific index?

934

What are the advantages of using cte?

1007

What is explicit mode in sql server?

1053

What is inner join? Explain with an example?

1206

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

1189

What is resultset concur_updatable?

1014

Can you leave a union at any time?

1055

How to find Duplicate Records In table?

1010

What is scd (slowly changing dimension)? : sql server analysis services, ssas

1001

Explain security with sql azure?

186

List all types of constraints in sql server?

1009

What is the default order of an order by clause?

988

What are subqueries in sql server?

1117

How can we call UDF(User Define Function) using C# code in ASP.net ?

6876