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

Automatically Detect Phone Model for WAP Jar Deployment
Making a wap site is fairly simple, but I'd like to know if there's a way to make it so that the wap

Expandable Post Code
Hi,

Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so i

Just a white page
Okay so, my website, when I click SignUp on it it takes me to /join.php but its a complete white pag

Escaped characters
I have a script that allows you to post news to the home page of my site. Along with the news is the

Using system() and bringing back the results
I am aware that you can use system() within PHP to execute system commands, but I was wondering if t

Check before inserting in DB ???
This is my code
---------------
if ( $_POST ['Submit'])
{{
$username = $_POST ['usernm

Displaying pictures
i have worked my way through storing images in directory and storing the location in mySQL db.Now i

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

displaying unknown amount of results
I am reading a directory and getting a list of folders in the directory, I want to display the folde

Dynamic Array using glob?
Is there an easier way to do this?

I am trying to get create a dyamic array based on files wi

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