delphi Asked:2020-01-16 17:51:40 +0000 UTC2020-01-16 17:51:40 +0000 UTC 2020-01-16 17:51:40 +0000 UTC SQL查询日相同记录数 772 在数据库中有一个登记表，其中 DEALDATE 列和 Transactio 列中的 DEALDATE 列用于加载日期，在 Transactio 中有 2 个不同的值，例如“Sale”“Return”。我需要按日期在查询中写入销售额，例如 |15.01.18|20| |16.01.18|12| 请帮助请求 sql-server 2 个回答 Voted Felix 2020-01-17T16:51:10Z2020-01-17T16:51:10Z SELECT Transactio, CONVERT(VARCHAR(10),DEALDATE,104)+'|'+CAST(COUNT(1) AS VARCHAR(10)) txt FROM table GROUP BY Transactio, DEALDATE Best Answer delphi 2020-01-19T05:46:28Z2020-01-19T05:46:28Z SELECT COUNT(Transactio) AS koli4estvo, CAST(DEALDATE as date) FROM TICKET WHERE Transactio='Sale' group by CAST(DEALDATE as date) order by CAST(DEALDATE as date)
SELECT Transactio, CONVERT(VARCHAR(10),DEALDATE,104)+'|'+CAST(COUNT(1) AS VARCHAR(10)) txt FROM table GROUP BY Transactio, DEALDATE
SELECT COUNT(Transactio) AS koli4estvo, CAST(DEALDATE as date) FROM TICKET WHERE Transactio='Sale' group by CAST(DEALDATE as date) order by CAST(DEALDATE as date)