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

Explain what are commit and rollback in sql?

980

How does a profiler work?

993

how can a database be repaired? : Sql server administration

1016

Can I save my report as html, excel or word? : sql server management studio

1007

Explain difference between cross join and full outer join?

1062

You accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover?

1033

What Is Rdbms?

1233

whats the maximum size of view state??

2248

how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

1723

What is user-defined function?

1033

Is it possible to call a stored procedure within a stored procedure?

1025

How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

2058

What is the difference between a unique key and primary key?

1002

Tell me what are cursors and when they are useful?

993

How does recursive cte works in sql server?

1059