Hello community,

I am strugling with what seems an easy problem to tackle (at least for me in MySQL / SqlServer!)

I'll simplify the problem. Let's say I have the following table:

Table VOTE

ID  ID_IDEA DATE_VOTE   with ID_IDEA FK(IDEA.ID)
1   3       10/10/10
2   0       09/09/10
3   3       08/08/10
4   3       11/11/10
5   0       06/06/10
6   1       05/05/10

I'm trying to find the latest votes given for each individual idea, meaning I want to return only rows with ID 4, 2 and 6.

It seems with Oracle that you can't use GROUP BY without using a function like SUM(), AVG, etc. I'm a bit confused about how it's supposed to work.

Please advise,

Thanks.