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

$variable $variables type question
I need to be able to designate an array element dynamically, so I thought to use a variable variable

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

Mail Script Problems
I have created a PHP mail script. I am having a problem though. In $body i am trying to put two va

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

Batch update record with Pagination
Hoping someone can help me with this issue I'm having, im trying to batch update records from a resu

Create or replace package is ending ORA-21700
Database 9.2.0., patch 8 (9.2.0.8.0).
I trying run
create or replace package ....etc.

small inaccuracies
I have this code to convert fractional base 10 into base 2:

while($num > 0)

standard ALV application toolbar, into custom report....
HI,

I have a question regarding displaying standard ALV menu path and application toolbar

LinkedList help
Ok so I just learned quickly about lists, so I have a not too hard project I think, but am having a

Display the user's weight lost in the past week
Hello everyone,

I am working on a weight loss app for my site, and I want to display the user