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

MS are the best!!!
Visit http://www.microsoft.com/australia/windows/default.aspx?h=watch-a-demo and click the massive '

session checking in page load
hai all I have a web site is www.Mryas.com in this my login page is Page1.aspx its co

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

Stumped by Third Day of Month problem
I am trying to build an algorithm that will essentially do this:
Code: [Select]$this_month = Oct

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

Rounding a number queried from a database
I know that to display a rounded number you just do echo "round($number)";. But how would

removing space from the end of a variable
i have a variable $image which contains the following url "http://tiles.xbox.com/tiles/oo/P5/0m

Breaking results into week blocks
I have a set of dates (and times), which are returned from a mySQL query.

These usually span

Preg_match with an array
is there an away to use preg_match with an array?

i want to check a string with an array to s

Motivational Posters
Hello,

I wonder how can i do them in php. Are there any sample codes that you can show me?

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