How to get time wise sales report in mysql, MySQL

How to get time wise sales report in mysql

Language: Layout:


absolute service time: 0,34 sec

edit mode | history

  
id
amount

1
1
2

2
2
3

3
3
0

4
4
0

5
5
0

6
6
9


  
id
(SELECT SUM(amount) 
     FROM tablename 
     WHERE id <= a.id)

1
1
2

2
2
5

3
3
5

4
4
5

5
5
5

6
6
14

λ

                                      .NET NoSQL database for rapid development