The difference between Union and Union all is that Union all will not eliminate duplicate rows, instead it just pulls all rows from all tables fitting your query specifics and combines them into a table. A UNION statement effectively does a SELECT DISTINCT on the results set.
Viewing 1 reply thread
You must be logged in to reply to this thread.Please login or register. Registration is 100% free.
GET FREE CONSULTATION
Call Us Now For Free Consultation97370 05566
Our experts listen to you patiently and suggest you the right course after conducting a personality profile test. Register your interest below to schedule personality profile test for you.