select max day for each month?

[bracchetto]

Hi,
I have a problem with a query to take records register different time in each month.
I want to select from a table only the records register in a max date in each month with NAME = ? AND DATE BETWEEN ? AND ?.

EX:
DATA VALUE NAME
30/12/2005 30,10 MARIO
30/12/2005 22,30 LUIGI
01/12/2005 50,45 MARIO
23/11/2005 10,40 LUIGI
20/11/2005 22,45 MARIO
10/11/2005 11,34 MARIO
09/11/2005 10,34 LUIGI
........
10/02/2005 23,34 MARIO
........

MY RESULT WOULD BE IF I REQUEST NAME='MARIO' AND DATA BETWEEN 01/11/2005 AND 31/12/2005 ORDER BY DATA:

20/11/2005 22,45 MARIO
30/12/2005 30,10 MARIO


THANKS

[NogDog]

What DBMS are you using?

[arunabh28]

Use Select query with group by month(control_date),year(control_date)