I have an sql table trade with following data

```
id| value | price
 1| 0.1   |1
 2| 0.5   |2
 3| 0.9   |2
 4| 0.3   |2

```

How do I make an SQL query so that I get the count of entries limited to total value of 0.9 for price 2 ascending by id . For example:-

```
Select Count of id FROM trade WHERE sum(value) <= 0.9 and price = '2'

```

Result should come as

```
 3

```

As there are total 3 entries with id 2,3,4 with values 0.5,0.9,0.3 with price 2 . The sum of them is 1.7 which is more than 0.9 but if we take 0.5 and 0.3 it combines to 0.8 which is lesser than 0.9 . So result should be 3 as it consists value of atleast 0.9 with price 2.

Also is there way to get the id of the results with last and first highest value in order.

So it looks like :-

```
4
2
3

```

Help appreciated :)