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

MASS PM
Hello all, I'm trying to send mass private messages to users in my database but keep getting an erro

contact form - output to page and email
I have the following in my controller:

$message['name'] = htmlentities(strip_tags(trim($_POST

mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:

from

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

adding 0 to numbers
Hey guys i need to create a 00001 number in a loop. Is there a better way of forcing a 5 digit numbe

problems with script
I made a small script wich exchanges points in my website:


<?php
session_start

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno

fopen() security
As i understood the usage of fopen() for it to function correctly the Dir you write to has to be rw

please help me... my password gets encrypted but not able to get in database
hai guys,
please help me... in the following function my password gets encrypted but no

login and redirect
hello! can someone help me.. can you give me an idea.. I want to make a login page and redirects it

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