問題描述

1，賬單表結(jié)構(gòu)

id money create_date1 102016-11-112 202016-11-12

2,需求是按日期排序，查詢總金額<=1000元的賬單列表數(shù)據(jù)

問題解答

select t.sum_money,t.date from (select sum(money) as sum_money,create_date as date from tablename group by create_date) t order by t.date;

若money為總金額，則SELECT id, money, create_date FROM TABLE WHERE money <= 1000ORDER BY create_date DESC

select sum(money) sums,create_date from talbe group by create_date having sums<=1000 order by create_date;