select max day per ogni mese? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

select max day per ogni mese?

Author

Topic

cavolobull
Starting Member

3 Posts

Posted - 2006-01-24 : 11:25:49

Salve,
ho un problema con una query per ricavare dei dati registrati più volte in un mese.
Io voglio selezionare da una tabella dei dati prendendo solo i dati registrati nella data più grande di ogni mese e delimitando la ricerca per una categoria e dando un limite di data.

ES:
DATA VALORE NOME
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
........

LA MIA QUERY MI DOVREBBE DARE SE RICHIEDO NOME='MARIO' DATA BETWEEN 01/11/2005 AND 31/12/2005 ORDER BY DATA:

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

Grassie

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-24 : 11:44:18

cen notte understande, writa en englishe

cavolobull
Starting Member

3 Posts

Posted - 2006-01-24 : 11:57:28

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

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-24 : 12:48:21

Try the following:

Select * from UrTbl
Where Data in (Select Max(DATA) from  UrTbl group by month(data))
      and NAME='MARIO' AND DATA BETWEEN 01/11/2005 AND 31/12/2005 
ORDER BY DATA

cavolobull
Starting Member

3 Posts

Posted - 2006-01-24 : 13:53:29

I have a problem with month():
>[Error] Script lines: 1-9 --------------------------
ORA-00904: "MONTH": invalid identifier

I'm using ORACLE ... !!!

UHMMM

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-01-24 : 14:20:16

Heh Heh,

Better to look in an Oracle Forum. This is a MS SQL Server forum. May be some guys in this also help u. Now I hardly remember any oracle stuff.

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2006-01-25 : 06:40:12

Try dbforums.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources