Union and Union All

Posted On: 2023-03-26 15:02:43 Database

The Union operator returns all distinct column value from two table where as union all returns all row selected by either query including duplicate, which does not eliminate duplicate row
Example:Select orderno from ordermaster union select orderno from orderdetails