Distinct and Group By哪個效率更高？的相關推薦_ITPUB論壇

SELECT distinct (T1.YEAR || '-' || T1.WEEK) AS CODE, T1.YEAR || '年' || T1.WEEK || '周' AS CODENAME, T1.WEEK FROM T1, T2 WHERE T1.ID = T2.ID AND T2.A = 10321002 AND T1.B = 10371001 AND T1.C NOT IN (10361003 ...

www.itpub.net