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

Simpler method of getting variables from mysql
Hi Guys,

I'm trying to streamline my CMS's code and as I was writing a new page it occured to

Adding post count
How would I make it so everytime someone clicks submit on my form, their row in the database for the

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Filtering an Array Based on Value
I have a very simple script set up that pulls data from a database and is output using this code:

disable all input buttons
Hello Friends,

suppose i do have a file ( file.php ) has a submit button

Code: [Sele

How to limit the calls to an API
Hello, in my simple script I call an api which effectively involves me getting an xml file.

H

PHP and MySQL on intranet?
Is it possible to use both these on an intranet network?

php automatically escaping single quotes
I'm trying to test out my security a bit and I've noticed that php is escaping my single quotes. For

FROM_UNIXTIME($phpdate);
Hello,

I tried to use this :

$date = FROM_UNIXTIME($phpdate);

ANd I was t

Lining up columns nicely.
Hello everyone, I'm having problems with making columns line up properly. Here is my code: