[SQL ]mssql GROUP BY
最近在使用Microsoft SQL Server Management Studio
下sql, 遇到一大堆錯誤
這一句
SELECT [Carname],SUM([TotalKm]) FROM [iiicar].[dbo].[relation]
GROUP BY [Carname]
會出現"除了使用 IS NULL 或 LIKE 運算子時之外,無法比較或排序 text、ntext 及 image 資
料類型"。
我的Carname是text TotalKm是float
表單長這樣
Carname | TotalKm
1 a 100
2 a 200
3 b 333
4 b 444
想要的樣子
Carname | TotalKm
1 a 300
2 b 200
謝大大們幫忙 謝謝
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 140.138.152.10
→
10/05 22:42, , 1F
10/05 22:42, 1F
→
10/05 22:45, , 2F
10/05 22:45, 2F
→
10/06 00:07, , 3F
10/06 00:07, 3F
→
10/06 00:07, , 4F
10/06 00:07, 4F
→
10/06 00:08, , 5F
10/06 00:08, 5F
→
10/06 00:17, , 6F
10/06 00:17, 6F
→
10/06 00:18, , 7F
10/06 00:18, 7F
→
10/06 00:18, , 8F
10/06 00:18, 8F
→
10/06 00:21, , 9F
10/06 00:21, 9F
→
10/06 00:21, , 10F
10/06 00:21, 10F
→
10/06 00:25, , 11F
10/06 00:25, 11F