UNION vs DISTINCT

Select Distinct is used to select distinct Combination of Cols , normally used with a JOIN.

UNION just Joins and gets distinct rows from two sets which have eaqul number of columns. So clearly you cannot apply one instead of other.

UNION ALL and UNION are discusses in terms of performance. UNION ALL is better as it does not depuplicates.

程式碼工作室
ERP/EIP/CMS/CHART/REPORT/SPC/EDA/雲端 系統開發整合
ASP/PHP/JSP/ASP.NET 網頁設計
技術指導顧問
信箱:paulwu0114@gmail.com
http://www.coding.com.tw