Self join is nothing but the table performs join condition itself same tabl

what is self join and why is it required? : Sql dba

Question Posted / suresh pagadala

Answer Posted / suresh pagadala

Self join is nothing but the table performs join condition itself same table is called self join

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Why do we use sqlite?

915

Which query operators in sql is used for pattern matching?

902

What is the difference between sql and t sql?

964

How do I view output in sql developer?

1027

What are the indexing methods?

1002

what is the syntax for using sql_variant_property? : Transact sql

987

What can I use instead of union in sql?

903

What is PL/SQL Records?

1114

Are subqueries faster than joins?

949

Is sqlite thread safe?

991

How do you determine the current isolation level? : Transact sql

1067

How do we use distinct statement? What is its use?

976

What programs use sql?

941

How do you concatenate in sql?

973

Can we write ddl statements in functions?

1051