Types of joins?

Answer Posted / mohana sundaram

self joins,natural joins,cross joins,inner joins,outer
joins,equi and nonequi joins.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is denormalization. : Sql dba

768


Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

735


What do you mean by stored procedures?

733


What are few of the schema objects that are created using PL/SQL?

733


What is left join in postgresql?

750






How do you go back in sql?

701


What does the hierarchical profiler does?

755


What is pragma in pl sql?

766


Is coalesce faster than isnull?

703


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

892


How do I install sql?

699


How many developers work on postgresql?

735


What is mutating table error?

882


what does the t-sql command ident_incr does? : Transact sql

805


Which join is default?

712