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

Which is better cte or subquery?

625

What is row_number () in sql?

631

Explain isolation levels. : Transact sql

659

what is a constraint? : Sql dba

809

What are sql constraints?

678

What are all ddl commands?

659

What is a schema sql?

627

What is the non-clustered index in sql?

664

What is date functions?

658

Can we join tables without foreign key?

609

Is subquery faster than join?

653

Why do we use procedures in pl sql?

618

What is view? Can we update view

966

What is the usage of nvl function?

690

can a stored procedure call itself or recursive stored procedure? : Sql dba

657