Union VS Union All



Union
Union All
used to combine ( set operation ) two or more query results

Used to combine (set operation) two or more query results

UNION will eliminate duplicate rows

UNION ALL will display all rows.

Comments

Popular posts from this blog

Restore of database 'DataBase_Name' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

Microsoft Power Platform Virtual Training Day: Fundamentals

The column with the SortKeyPosition value of 1 is not valid. It should be 0