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

Variable uses and placement
I'm new to PL/SQL and am trying to learn about variable valid uses/placement (any pointers to any do

how to remove in php string display
My code is

$message="We're looking at developing our website.";

$body= "

selectbox+database connection retrive problem
Code: [Select]
<tr>
<th align="left" scope="c

Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to ret

Check premium expire
Hi,

I am making a simple file hosting site and want to check if users premium subscriptions h

need help about
i store the value of my select statement result to an array and stored it to a variable named $fname

Loop Through Date Range
Hi guys,
I have date range as parameter like 01/JAN/2009 TO 16/JAN/2009 now i want to loop thro

Login script (probably a simple error)
dbConfig.php
Code: <?
// Replace the variable values below
// with your specific dat

sapgui f4 help last search
I know this has to be simople. One user (maybe more) does not have the "last search saved" from the

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

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