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

how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt ?
how to put the 0-100 numbers into 1.txt and 100-200 into 2.txt and so on 200-300 into file 3.txt ?

Find occurences of unicode characters in string
I need to prohibit filenames with everything but English characters and numbers but regexp and strin

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

Preventing SQL Injection
I have a question about SQL Injection, In some of our code we use this: view plaincopy to clipboa

how to use two buttons with php
hi i have one form. there are three fields which are to be filled by the user. and then there are tw

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

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

What is SAP Avatar ?
Hi All,

This G.Satish , my boss asked me to explore on SAP Avatar. I searced in internet

Keep newlines from textarea?..
I'm creating a simple encoding program, and what I want it to do is retain the newlines, as echoing

Image resize
Hi again fellers

I managed to sort out the issues with the folder,

Final hurdle is th