union is used to select distinct values from two tables where as union al

what is the difference between union and union all

Question Posted / ranjay kumar singh

Answer Posted / ranjay kumar singh

union is used to select distinct values from two tables
where as union all is used to select all values including
duplicates from the tables

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How global cursor can be declare with dynamic trigger ?

2189

how to drop an existing view in mysql? : Sql dba

1043

What are inner and outer joins examples of both?

940

how to create a table index in mysql? : Sql dba

1037

Can a trigger call a stored procedure?

1052

how to include numeric values in sql statements? : Sql dba

1083

what is rdbms? : Sql dba

998

What are stored procedures in mysql?

1005

Can we use ddl commands in pl sql?

1136

Differentiate between sga and pga.

1143

How do I run a script in sql developer?

936

What is scalar function in sql?

1021

Which is faster joins or subqueries?

973

What is delimiter sql?

966

Explain the savepoint statement.

1083