what is self join and how it works??

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Do we need to create index on primary key?

471


Does mysql support pl sql?

628


What are operators available in sql?

592


How do I start sql profiler?

561


How do you get column names only for a table (sql server)?

672






Why is pl sql needed?

517


Are sql database names case sensitive?

505


What are the two virtual tables available at the time of database trigger execution?

647


What is the difference between the sql*loader and import utilities? : aql loader

604


What is dynamic sql in pl sql?

499


What is dense_rank in sql?

546


What are different functions in sql?

521


List the different type of joins?

575


How many commands are in sql?

530


Can we call stored procedure in function?

559