Helen M Hudson ha scritto:
> So, if my table structure was:
> id | date | order_ref | amount
> 1 | 1/1/01 | 100 | 1000 << these 2 are the rows
> 2 | 1/1/01 | 100 | 200 << i want to exclude
> 3 | 2/1/01 | 100 | 1000
> 4 | 2/1/01 | 100 | 200
> 5 | 2/1/01 | 100 | 50
>
> I'd like to end up with
> latest_date_on_order | order_ref | sum(amount)
> 2/1/01 | 100 | 1250
>
> I know its a one-liner for someone who has reached the light... so any help very much
> appreciated!
>
I do not know if i can give you the light because my english is not as
good as I'd like.
If i've understood your question, you can try this SQL statement:
SELECT max( `date` ) AS 'date', sum( `amount` ) AS 'amount'
FROM `Prova`
WHERE `order` =100
GROUP BY `order`
LIMIT 0 , 30
Enjoy and please tell me if it solves your problem...
--
vittorio zuccalà
Finconsumo Banca SPA
vittorio.zuccala@stripped
Tel: 011-6319464
