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

Internal class functions don't seem to get executed.
Hi. Can someone please put me out of my misery on this. I don't write much PHP and this has me baffl

why preg_match_all does not return the number of matches
My regex looks like

X[^x{4e00}-x{9fa5}]*Y

(where X and Y are two Chinese characters)

Delete Client 066 Earlywatch
Hi all,

in former times client earlywatch was required for SAPs remote access to SAP inst

Connect to database that isn't localhost
I am currently doing a small script for a company that doesn't have mySql support on there hosting.

php mysql script to find record
Hi,

Currently I have a simple table with 4 columns. A, B, C, D

If I want to find all

This must be easy , pulling the last record of the day, every day, from a txt
I have a txt file logging weather data every minutes (so 1 record per minute). I want to extract the

writing a screen scraper
Hello,

I'm writing a screen scraper application and want to be able to get absolute addresses

Custom CMS
This is a big custom CMS script I'd like to develop and would like some help atleast figuring out wh

Check if another session of the page is running?
I want to keep people from opening multiple tabs, or sessions of my Facebook app. Is it possible to

How do I use ValidatorCallout extender in Login control?
Hi,I'd like to customize the look and feel of the login control a little bit. One thing I'd love to

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