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

Any meaningful project for a new C++ programmer?
I want to do some meaningful program, so I can help myself to learn

Assume I know the fol

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

pagination numbering pattern
Hello,

I have following code which works great for pagination. but i have small issue now.

reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos

While Problem
i am having a problem with a while statement here is the code
Code: [Select]<?php
sess

Printing a webpage
I use this to print the webpage: o

Thread in PHP
Thread in PHP
Some basic use and basic code for thread in php
This is my question?

CE 7.1 and External GIS integration
Hi All,

We want to develop an application on CE 7.1 which uses GIS features from an exter

apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?