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

IS this code correct
The reason i ask is everything underneath it appears to be alink as well, tis blimmin annoying

Restricted access to sub-folder in iis6 doesn't work?
Basically I'm trying to add restriction to sub-folder (which contains pdf) in web.config for iis6 as

$_GET problem
Hi all,

Have a bit of a problem with a little piece of code, I am not sure if this should be

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

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

DATEDIFF Question
First time post, and of course it is a help question.

I am using a WP plug-in to display prev

PHP onsubmit in the form not going to the fuction.
I have a form through ‘onsubmit’ calling a function validation(). But not going to the

How to extract/download content from HTTPS page?
Hello to all the Members of this forum, Im Shoiab, A novice programmer in php.. for my first job I h

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname