Problem using Max()

I have a table activity with following fields

Table:activity

activity_id proof_pages chapter_id
-------------- ---------------- --------------
1 23 10
2 32 10
3 10 15

now i need to get the max(proof_pages) and the corresponding activity_id.

i used the following query:

select activity_id,max(proof_pages) from activity
where chapter_id='10'
group by chapter_id

Output:
-------
activity_id = 1
max(proof_pages)=32

but the actual result should be
activity_id=2
max(proof_pages)=32

how should i modify the query?
Thanks,
Thanuja

Why are you using the group clause? I think it will work, correctly, without it.

If i dont use group by then i get this following error:

Error:1140
Mixing of GROUP columns (MIN(),MAX(),COUNT()...) with no GROUP columns is illegal if there is no GROUP BY clause

so need to use gorup by .

Thanks,
Thanuja.

I think I had an odd moment when I made that suggestion. Try

select activity_id from activity where chapter_id='10' order by proof_pages desc limit 1

Ya thats ok. I tried this query and it works. Thanks.

Thanuja.