Group by particulier

Version imprimable

10/04/2006, 15h05
Bjuice2

Group by particulier

Bonjour,

J'ai un etable de type

ID | VILLE | Date

JE veux ressortir pour chaque ID la derniere ville connue en fonction de la date.

Merci par avance,

Bonjour,

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
CREATE TABLE T_MATABLE_TBL
(TBL_ID     INT,
 TBL_VILLE  VARCHAR(32),
 TBL_DATE   DATE)
 
INSERT INTO T_MATABLE_TBL VALUES (1, 'PARIS', '2005-12-01')
INSERT INTO T_MATABLE_TBL VALUES (1, 'PARIS', '2006-01-01')
INSERT INTO T_MATABLE_TBL VALUES (2, 'LYON',  '2004-11-21')
INSERT INTO T_MATABLE_TBL VALUES (2, 'LYON',  '2005-04-16')
INSERT INTO T_MATABLE_TBL VALUES (3, 'LYON',  '2005-01-01')
 
SELECT *
FROM   T_MATABLE_TBL T
WHERE  TBL_DATE = (SELECT MAX(TBL_DATE)
                   FROM   T_MATABLE_TBL T2
                   WHERE  T.TBL_ID = T2.TBL_ID)

A +

Ce n'est pas exactement ca .
j'ai corrigé les insert:

Code:

1
2
3
4
5
6
7
8
9
10
11
 
CREATE TABLE T_MATABLE_TBL 
(TBL_ID     INT, 
 TBL_VILLE  VARCHAR(32), 
 TBL_DATE   DATE) 
 
INSERT INTO T_MATABLE_TBL VALUES (1, 'PARIS', '2005-12-01') 
INSERT INTO T_MATABLE_TBL VALUES (2, 'PARIS', '2006-01-01') 
INSERT INTO T_MATABLE_TBL VALUES (3, 'LYON',  '2004-11-21') 
INSERT INTO T_MATABLE_TBL VALUES (4, 'LYON',  '2005-04-16') 
INSERT INTO T_MATABLE_TBL VALUES (5, 'LYON',  '2005-01-01')

Et je voudrais qu'elle me retourne :
1 , 'PARIS', '2006-01-01'
4, 'LYON', '2005-04-16'

Merci @+

11/04/2006, 09h13
Bjuice2

Comment puis je faire ?

Code:

1
2
3
4
5
6
 
SELECT *
FROM   T_MATABLE_TBL T
WHERE  TBL_DATE = (SELECT MAX(TBL_DATE)
                   FROM   T_MATABLE_TBL T2
                   WHERE  T.TBL_VILLE = T2.TBL_VILLE)

A +

11/04/2006, 10h57
Bjuice2

LE concept est génial !!!!!

Tu es trop FORT !!!!

Merci bcp !!!