Sql服务器中的每日销售额总和

Question

我在sql server中有一个类似的表

userid username sale date 
 1       azad    50  12/07/2013 
 2       akash   40  12/07/2013
 3       sushil  30  12/07/2013
 4       pankaj  20  12/07/2013
 5       akash   40  12/07/2013
 6       sushil  30  12/07/2013
 9       pankaj  20  12/07/2013

现在我想要所有用户的销售日期的总和，但从上次销售到所有用户，我想要像这个一样的输出

ClosingBalance
140

该结果基于所有四个用户的最后一个条目

Answer 1

WITH T AS
(
SELECT *,
       ROW_NUMBER() OVER (PARTITION BY username ORDER BY date DESC, id DESC) AS RN
FROM  Balances
)
SELECT SUM(sale)
FROM T
WHERE RN=1

SQL Fiddle

Answer 2

$sum_sale= mysql_query('SELECT sum(sale) FROM `TABLE` AND '2011-12-09' BETWEEN startdate AND enddate;');
$sum_sales_total = mysql_fetch_array($sum_sales);

这应该对你有帮助。