+ Reply to Thread
Results 1 to 2 of 2

Thread: UNION and UNIONALL ?

  1. 11-10-2011 06:56 AM #1
    sana86
    sana86 is offline
    Emerald Star member sana86 is on a distinguished road
    Join Date
    Oct 2011
    Posts
    117

    Default UNION and UNIONALL ?

    What is the difference between UNION and UNIONALL in oracle?
    UK Business Directory
    Reply With Quote Reply With Quote
  2. 04-30-2012 10:23 AM #2
    suba
    suba is offline
    Sapphire Star member suba is on a distinguished road
    Join Date
    Sep 2011
    Posts
    92

    Default What is the difference between UNION and UNIONALL in oracle?

    The main difference is that UNION will eliminate any duplicate rows returned by the various select statements being unioned whereas UNION ALL will not. It will return all records even duplicates.
    plc training in chennai|plc training in coimbatore|plc training in india
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules