why this query can delete duplicates ?

Posted on 16th Feb 2014 07:03 pm by admin

why this query can delete duplicates ? Anybody can give me the detailed explanation ?

Thanks

select salary from employees union select salary from employees;

Your Answer:

Login to answer

Other forums

Pass sql into pl/sql and create RMAN duplicate script.
Hi,

I'm new to pl/sql and I'm trying to write a script that will generate some RMAN comma

* Gridview and Detailsview in UpdatePanel, insert mode problem
I have a GridView and DetailsView working together. When a record from Gridview is selected, Detail

Agency Business Process
Hi,

I don’t understand the process of the agency business in SAP.

In my

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

I need some help with the IF command...
I have a large number of images in one section of my website with the .jpg format. I'm adding a bun

Count Session and Trigger Events
I am New in PHP, seeking a method to count logged users by counting the sessions or any …, is

distinct rows
Hi
version 10.2.0.3

I have a query output something like the following

ID

Getting number of affected rows in SQLPLUS..
Hi everyone,
I have a shell script where i am invoking sqlplus, running a query and saving t

Array question
Does anyone know how to create a program that takes the $ amount for 8 different departments and gi

Upload file and add HTML
Hey everyone,

I have a client has meeting agendas and minutes that should be posted online. I