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;

No comments posted yet

Your Answer:

Login to answer
203 Like 28 Dislike
Previous forums Next forums
Other forums

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

trouble printing an array....
I'm having some trouble printing out an array forwards. I'm figuring out the high and low of an arra

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

Results from Db outputted twice
Hey guys.. for come reason my data is outputted twise shown in the image below and i cant figure out

LOOPing Problem
Hello All!

The following code loops through the data and displays the data accordingly. My p

limitations on array_unique()
Does any one know what/how imitations are applied to array_unique? I have an issue where no matter h

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

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash