sql - 如何在 SQL Server 中将两行合并为一行

Question

我正在尝试编写一个 SQL 查询，其想法是将两行合二为一。表演时

select * from caixa

我得到以下结果：

id   money    open                closed        fun  type  situation
--------------------------------------------------------------------
13    10      08/09/2018 18:55                   1    E     1
37    -473                  09/09/2018 17:01     1    F     1
40    0       09/09/2018 17:08                   1    E     2
41    0                     10/09/2018 17:09     1    F     2

这个想法是加入情况相同的两行，例如：

money     open                   closed        fun  type  situation
--------------------------------------------------------------------
-473      08/09/2018 18:55  09/09/2018 17:01    1    E      1

标签： sqlsql-server

Answer 1

您可以尝试使用聚合函数来制作它

SELECT MIN(money) as money ,MAX(open) as open,
       MAX(closed) as closed,fun,MIN(type) as type,
       MIN(situation) as situation
FROM caixa
GROUP BY fun