Retrieving query

[Larry Regencia]

hello guys,

i would like to ask again about your expertise with regards to sql queries. i belive this is pretty easy but the results i have are not the ones I wanted. Here's the scenario:

Table A
id stockcode runningbalance
1 A1 100.00
2 A2 100.00
3 A1 50.00
4 A3 200.00
5 A2 150.00
6 A4 350.00
7 A5 250.00
8 A1 150.00


Results that I wanted should be:

id stockcode runningbalance
8 A1 150.00
5 A2 150.00
4 A3 200.00
6 A4 350.00
7 A5 250.00

The results I need is to retrieve the last data, group by stockcode. I have tried several queries already and I was able to retrieve the id and stockcode but the runningbalance was not the latest, it was the runningbalance of the first record.
Any idea would very much appreciated. Thanks a lot.



Larry Vincent