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 help
Does anyone know how to require 10 text fields for individual grades and output class average? (10 p

am I using this for loop correctly
Dear buddies!

Right now I am generating a report with some details for all the dealers.

Displaying a clickable playername
I am going wrong somewhere with the mysql_query, can someone please put me straight?

$playern

Only add new information from XML to MySQL
What I am doing, is taking a xml file, and adding the values to a database. However, what I want to

Detail Expenses Report by Cost Center
I would like to obtain a report out of SAP that shows a list of expenses by cost center that shows t

Placing and array within an array then sorting it!
I have a page that runs two large mysql queries and saves the results into arrays, in php I then per

UPLOAD IMAGES NOT WORKING!
Hi there i have a upload script in which it uploads the picture to a folder than creates two thumbna

Dynamic memory problem
Hey,

At the beginning of my code, I have this line:

Shape* gShape = 0;

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

form problem
below in the form action, i've put "test.php?w=$sw&h=$sh" but when i input the for