我有表如下图所示。我想总结的部分柱和最后一个记录后的总写。如何指定总的结果SQL查询。

 模型零件

                  型号1 4
                  模型2 2
                  Model3 6
                  Model4 5
                  Model5 7
                   共有24
 

解决方案

试试这个查询

  SELECT车型，配件
从your_table
联盟
选择合计为榜样，SUM（部分）由于零件your_table
 

I have table like below. I want to sum parts column and write the total after last record. how to specify total and the result in sql query.

                   Model  parts

                  Model1      4 
                  Model2      2
                  Model3      6
                  Model4      5
                  Model5      7
                   Total     24

Try this query

SELECT  models, parts
FROM    your_table
UNION
SELECT  'Total' AS models, SUM(parts) AS parts from your_table