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

array empty
Hiya peeps,

Ok here is the codes.

order.php

Code:

double and single quotes in text fields acting up... help please
Single quotes, when entered into a text field, create an sql error upon Submit. It seems to create t

Data type mismatch
Hi,
I am migrating data from algol to c.I mapped real datatype in algol to double datatype in

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

Can we convert non uni code system into unicode
Hi All,

Presently i am using non-unicode system and the sap version is 4.7.
Can i c

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Conditions of info record - Error
When i created GR (901) and PO create automatic my PBXX is obtain the net price of info record but

Help with syntax
Hi all!

The $bridge variable is not getting passed while it is contained in the line below:

Remove values in array2 from array1
I have two arrays.

Array 1 is where the array key holds various different numbers. For exampl

an interesting question
Greetings folks, got to ask an interesting question...

let say
i have created a function s