A join joins with itself is called self join Working with self joins we us

What is a self join? Explain it with an example?

Question Posted / ganesh

Answer Posted / ganesh

A join joins with itself is called self join
Working with self joins we use Alias tables

Is This Answer Correct ?

96 Yes

21 No

Please Help Members By Posting Answers For Below Questions

How to read and create .LDC data files which are used by linguatic dictionary.

2479

Who are naive users?

956

Explain about a primary key?

932

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

950

How to use online Backups?

2154

Which four data types cannot be used as a return type from a user-defined function?

968

How is data stored in dbms?

890

Explain about normal forms?

998

What is dbms and its application?

945

Explain what a database is?

984

Explain about network model?

951

Explain the process of the user request and data generating?

1039

Explain about the relational database?

1003

Explain about the storage and physical database design?

869

What is the database development process?

1156