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 are the essential components of sql server service broker?

1019

What is implicit cursors?

1085

Can we call stored procedure in view in sql server?

898

What is the difference between mysql and mysqli?

1203

Explain trigger and trigger types?

984

What is dbcc? Give few examples.

1036

Give the query of getting last two records from the table in SQL SERVER?

963

Explain temporary table vs table variable by using cursor alternative?

999

How will you know when statistics on a table are obsolete?

1082

Is port 1433 secure?

997

What will be the maximum number of index per table?

1006

What do mean by xml datatype?

1103

How do I clean up sql server transaction log?

1066

Write a program to fetch first 10 records from a file?

1011

Why do we use sql limitations? Which constraints can we use while making a database in sql?

1077