JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TAB

Explain SELF JOIN ?

Question Posted / sandhya

Answer Posted / sandhya

JOINING TO TABLE ITSELF IS CALLED SELF JOIN. HERE WE ARE USING THE SAME TABLE WITH DIFFERENT ALIYAS'S.

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is the federation in sql azure?

How self join is different from outer join?

1061

How to generate create procedure script on an existing stored procedure?

937

What is the command used to check locks in microsoft sql server?

972

What is ssl in sql server?

1011

Differentiate between truncate vs delete in mssql?

995

What is cte (common table expression)?

977

How to create user defined functions with parameters?

1164

How to create a large table with random data for index testing in ms sql server?

978

How do I change my passwords (database, LDAP, and so on) without causing an outage?

1017

Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .

1902

How secure is sql server database?

954

Why use “nolock” in sql server?

983

Does partitioning improve performance sql server?

897

Describe in brief databases and sql server databases architecture.

942