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

Why is my row count 0?
Here's the MySQL query i'm running. It basically pulls data from 2 tables based on some data passed.

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

Keeping data in form
How can I keep whatever I write in the form?

Multidimensional $_POST
Hello

How to get a single array from array of array (2 - dimension).
For example I have a

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

Files in current folder. Should be an easy fix.
Never mind. I've asked about this before and just found my answer. Anyway to delete this?

Comparing two dates
Hi Guys
I have two dates I want to compare. Below is my current implementation. The problem with

Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct

cURL error
So here is my code... I got it off of here... http://www.youtube.com/watch?v=XcgQUsorF_8
Because

Change image filetype on upload?
Hi,
I've got a form which uploads an image to the server.
Is it possible to change the image t

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