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

Need help with a mail notify function
I was tasked with setting up a site that's been prewritten. The site is basically a form that captur

dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i

WORDPRESS - Multiple Loops Only Going to One Post?
I have various pages with multiple loops and i need them to be individual to all other categories.

Fetching META TAGS through
Hello everybody
I want to fetch meta tags of a domain.
It will be done from following code of

Character increment
Hi,

I am facing a scenario like above,but in my case i want to show up like Col A,Col B etc..

my two tables
table1 : col1 = topicid , col2 = topic

table2 : col1 = sentid, col2 = sentence

Cod

Echoing ASCII code
I have a php page that splits a string into chars and then echoes the ASCII code for each char. I'm

GIS appliction help
I found some tutorials in the internet to develop a map application I don't want to use google maps

PHP Search Issue
Hi, I am using the following code to search and return flights from a database. The user searches by

Disable html within defined tags
I have a mysql database that allows users to enter content with html, but I also want to have a tag