What are the type of joins? When do we use Outer and Self joins?

Answer Posted / shivanibehere

For the joins you can go for this link ----
http://www.databasejournal.com/features/oracle/article.php/3
527921

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How will you decide the active and passive nodes?

787


What is checkpoint process in the sql server?

708


what are the new features introduced in sql server 2000? : Sql server database administration

697


explain what is raid and what are different types of raid configurations? : Sql server database administration

727


Explain system rowset functions?

737






How to disable triggers using "disable trigger"?

779


what is a join? : Sql server database administration

746


Explain what are the events recorded in a transaction log?

731


What are trace flags?

765


Explain table valued parameters in sql server? Why tvp used?

728


Can select statements be used on views in ms sql server?

766


What is the use of partition by in sql server?

668


What are triggers in ms sql server?

795


Ways to improve the performance of a SQL Azure Database?

115


Explain the disadvantages/limitation of the cursor?

710