[問卦] 為何開票不直接用sql統計就好
如題
在那邊一張一張唸 然後還在那邊畫正字號
為什麼不直接寫sql 然後快速統計
Create table result as
Select
Name,
Count(*) as count
From data
Group by name
Order by name
;
這樣不就可以超快速統計完了
有沒有不用sql的八卦
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 101.10.106.192 (臺灣)
※ 文章網址: https://www.ptt.cc/bbs/Gossiping/M.1705134760.A.172.html
噓
01/13 16:33,
3月前
, 1F
01/13 16:33, 1F
噓
01/13 16:33,
3月前
, 2F
01/13 16:33, 2F
→
01/13 16:33,
3月前
, 3F
01/13 16:33, 3F
噓
01/13 16:33,
3月前
, 4F
01/13 16:33, 4F
噓
01/13 16:33,
3月前
, 5F
01/13 16:33, 5F
推
01/13 16:33,
3月前
, 6F
01/13 16:33, 6F
推
01/13 16:33,
3月前
, 7F
01/13 16:33, 7F
噓
01/13 16:33,
3月前
, 8F
01/13 16:33, 8F
噓
01/13 16:33,
3月前
, 9F
01/13 16:33, 9F
噓
01/13 16:34,
3月前
, 10F
01/13 16:34, 10F
→
01/13 16:35,
3月前
, 11F
01/13 16:35, 11F
推
01/13 16:35,
3月前
, 12F
01/13 16:35, 12F
推
01/13 16:35,
3月前
, 13F
01/13 16:35, 13F
噓
01/13 16:35,
3月前
, 14F
01/13 16:35, 14F
→
01/13 16:35,
3月前
, 15F
01/13 16:35, 15F
噓
01/13 16:35,
3月前
, 16F
01/13 16:35, 16F
推
01/13 16:35,
3月前
, 17F
01/13 16:35, 17F
→
01/13 16:36,
3月前
, 18F
01/13 16:36, 18F
→
01/13 16:37,
3月前
, 19F
01/13 16:37, 19F
噓
01/13 16:43,
3月前
, 20F
01/13 16:43, 20F
推
01/13 17:14,
3月前
, 21F
01/13 17:14, 21F