- 163 月
-
善用 ORDER BY 位置順序編號
當 UNION ALL 匯集好幾個查詢語句,而偏偏要用來排序的欄位,在各查詢語句中的欄位名又不一致時,這時 ORDER BY 查詢結果中某一個欄位的位置順序編號,就很好用- Posted by admin Posted on 16 3 月 0 Comments Read More
- 201 月
-
字串的日期比對 vs BETWEEN AND 語法效率
查證後...用字串的日期比對,會比用 BETWEEN...AND 語法,來得有效率- Posted by admin Posted on 20 1 月 0 Comments Read More