UNION ALL

How do you get all records from 2 tables. Which join do you use?

Question Posted / sri

Answer Posted / sri

UNION ALL

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain foreign key in sql?

1020

how can we submit a form without a submit button? : Sql dba

984

What is data abstraction in sql?

1023

What is data profiling in sql?

1074

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

947

what is query cache in mysql? : Sql dba

1032

what is a materialized view? : Sql dba

1061

What is input buffer in sql*plus?

1217

What is primary and foreign key?

1059

What is embedded sql in db2?

1013

Define commit, rollback and savepoint?

1024

How does sql developer connect to oracle database?

998

What is composite data type in pl sql?

1101

Is join and inner join the same?

1000

How many joins can you have in sql?

934