Home » SQL & PL/SQL » SQL & PL/SQL » Difference between UNION ALL and UNION
Difference between UNION ALL and UNION [message #20533] Sun, 02 June 2002 22:38 Go to next message
Bharathi
Messages: 6
Registered: March 2002
Junior Member
Hi all,
i want to know the difference between UNION ALL and UNION and few examples as to when i can use them.
Few resources on these topics would be good....

Thanks in adv

Report message to a moderator

Re: Difference between UNION ALL and UNION [message #20534 is a reply to message #20533] Mon, 03 June 2002 00:29 Go to previous message
Vikas Gupta
Messages: 115
Registered: February 2002
Senior Member
Hello,

UNION: Oracle will eliminated duplicate records, just like distinct clause.

UNION ALL: Does not eliminate the duplicate records,
returns all the records.

Vikas.

Report message to a moderator

Previous Topic: Re: working with dates
Next Topic: Re: Mutation Error for Update Trigger
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 01 11:03:46 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.