The Concept of joining a table with it self in called "self join"

What is Self Join?

Question Posted / ramesh

Answer Posted / ramesh

The Concept of joining a table with it self in called "self
join"

Is This Answer Correct ?

15 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can a table have 2 foreign keys?

958

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1268

What are different backups available in sql server?

1157

What is dknf in normalization form?

1114

What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas

1026

What is update locks?

938

What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio

1189

What are database states in ms sql server?

1247

What do you understand by triggers?

979

Explain indexing and what are the advantages of it?

1071

what are acid properties? : Sql server database administration

1060

What do you mean by authentication modes in sql server?

1136

When would you use the stored procedures or functions?

1054

Why I am getting "the microsoft .net framework 2.0 in not installed" message?

1056

Can a database be shrunk to 0 bytes, if not, why?

1167