[SQL] Combiner fonction d'agrégation et DISTINCT .

Version imprimable

[Résolu][SQL] Combiner fonction d'agrégation et DISTINCT .

salut à toutes à à tous,

j'ai pb sur une requete , voici ma requete d'origine :
Code:

1 2 3 4 5 6 SELECT PHYSIC_PAGEID_PK , ISNULL(SUM(NUMBERPOSTINGPAGES),0) AS NB FROM TRACKING_PHYSIC_PAGE , TRACKING_POSTING_PAGE , TRACKING_DAILY_CALENDAR WHERE PHYSIC_PAGEID_PK = PHYSIC_PAGEID_FK AND DAILY_CALENDARID_FK = DAILY_CALENDARID_PK AND YEAR = 2004 GROUP BY PHYSIC_PAGEID_PK ORDER BY NB DESC
je souhaite faire un distinct sur un champs nommé PHYSIC_PAGEURL de la table TRACKING_PHYSIC_PAGE , j'ai pensé à une sous requete mais je ne vois pas trops ou la mettre.. un peu d'aide serait binevenue ..
merci !!

ps : sgbd : sql server

Code:

1
2
3
4
5
6
7
8
9
Select PHYSIC_PAGEID_PK , NB
From
(SELECT PHYSIC_PAGEID_PK ,
             ISNULL(SUM(NUMBERPOSTINGPAGES),0) AS NB 
FROM TRACKING_PHYSIC_PAGE  , TRACKING_POSTING_PAGE , TRACKING_DAILY_CALENDAR 
WHERE PHYSIC_PAGEID_PK = PHYSIC_PAGEID_FK 
   AND DAILY_CALENDARID_FK = DAILY_CALENDARID_PK 
   AND YEAR = 2004 GROUP BY PHYSIC_PAGEID_PK)
 ORDER BY NB DESC

A+

Citation:

Envoyé par MAMMAR

Code:

1
2
3
4
5
6
7
8
9
Select PHYSIC_PAGEID_PK , NB
From
(SELECT PHYSIC_PAGEID_PK ,
             ISNULL(SUM(NUMBERPOSTINGPAGES),0) AS NB 
FROM TRACKING_PHYSIC_PAGE  , TRACKING_POSTING_PAGE , TRACKING_DAILY_CALENDAR 
WHERE PHYSIC_PAGEID_PK = PHYSIC_PAGEID_FK 
   AND DAILY_CALENDARID_FK = DAILY_CALENDARID_PK 
   AND YEAR = 2004 GROUP BY PHYSIC_PAGEID_PK)
 ORDER BY NB DESC

A+

merci MAMMAR, mais,

Code:

1
2
Serveur : Msg 156, Niveau 15, État 1, Ligne 9
Syntaxe incorrecte vers le mot clé 'ORDER'.

me dit sql server...

en virant

Code:

ORDER BY NB DESC

ç ame fait

Code:

1
2
Serveur : Msg 170, Niveau 15, État 1, Ligne 8
Ligne 8 : syntaxe incorrecte vers ')'.

normal il manquait un alias pour la sous requête.

Code:

1
2
3
4
5
6
7
8
9
Select PHYSIC_PAGEID_PK , NB 
From 
(SELECT PHYSIC_PAGEID_PK , 
             ISNULL(SUM(NUMBERPOSTINGPAGES),0) AS NB 
FROM TRACKING_PHYSIC_PAGE  , TRACKING_POSTING_PAGE , TRACKING_DAILY_CALENDAR 
WHERE PHYSIC_PAGEID_PK = PHYSIC_PAGEID_FK 
   AND DAILY_CALENDARID_FK = DAILY_CALENDARID_PK 
   AND YEAR = 2004 GROUP BY PHYSIC_PAGEID_PK)  as TRACK
 ORDER BY NB DESC

A+

02/12/2004, 17h08
p@radox

ok merci

A+
02/12/2004, 17h11
MAMMAR

n'oublies pas le tag [Resolu].

A+