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 to prepare for oracle pl sql certification?

1109

What is not equal in sql?

1194

Is subquery faster than join?

1063

Sql technical questions

1334

What is offset and limit in sql?

1105

What is dbo in sql?

1019

What are the possible values that can be stored in a boolean data field?

1042

What is difference between stored procedures and application procedures?

1067

What does select count (*) mean in sql?

1075

What do you mean by query optimization?

1050

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

2166

Why are aggregate functions called so?

1012

What is a common use of group by in sql?

1096

How can you save or place your msg in a table?

1041

Is oracel sql developer written in java?

1169