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 named query? : sql server analysis services, ssas

1001

What is the standby server?

998

Explain nested trigger in sql?

1128

What is advantage data architect?

975

What is difference between cte and view?

974

What is sql server profiler trace data file?

1177

What is table join?

1170

what is the main function of a query parameter?

155

How to create a scrollable cursor with the scroll option?

1047

What is the difference between row_number and dense_rank?

934

How do I find information about the install locations for the various instances running on a computer?

1123

Find first and last day of current month in sql server

1080

Is candidate a key?

1002

What do you understand by recursive stored procedures?

1043

difference between Clustered index and non clustered index ?

1032