I have the following sample table structure:
id | facilityId | accountId |   date   | timestamp | amount
-------------------------------------------------------------
1       ABC          100      20100401   272300000     55
2       ABC          300      20100401   272300000     50
3       ABC          100      20100402   272400000     60
4       ABC          300      20100402   272400000     10
5       ABC          100      20100402   272500000     30
6       ABC          100      20100402   272600000     35
7       ABC          300      20100402   272700000     30
My sudo-query is: I'm trying to get the sum(amount) as totalAmount for each distinct accountId, where date >= 20100401, using the most recent timestamp of each accountId. I'm looking for some help with the query/sub-select requirements.
Example result:
accountId | totalAmount
------------------------
   100          90
   300          80
I specifically want to check and use the latest timestamp, and not rely on the id.
Thanks.