Joining the Table data it self is called self join,it will work based on th

what is self join and how it works??

Question Posted / srinu

Answer Posted / srinu

Joining the Table data it self is called self join,it will work based on the join condition

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the different types of dbms?

1016

Explain polymorphism in pl/sql.

1120

How can a pl sql block be executed?

945

Can we create table in function?

964

Does sql*plus also have a pl/sql engine?

1080

When are we going to use truncate and delete?

989

Explain locks? : Transact sql

1005

What is sqlcontext?

1084

What is sql not null constraint?

1037

what is 'mysqld'? : Sql dba

969

Why truncate is faster than delete?

1111

Is left join faster than join?

1053

what is a materialized view? : Sql dba

1061

Does asenumerable execute the query?

1044

How do I find duplicates in two columns?

1169