Group by and Order by in the same select

Question

i've this query:

  SELECT MODELLI.MOD_DESC, 
         COUNT(MOD_DESC)
    FROM VEGA.DISTRIB AS DISTRIB, 
         VEGA.MODELLI AS MODELLI
   WHERE DISTRIB.DIS_FLAG = 'M' 
     AND DISTRIB.DIS_MOD = MODELLI.MOD_COD
   GROUP BY MODELLI.MOD_DESC

But i want to have the ORDER BY on MODELLI.MOD_DESC too.

How i can do this?

Thanks.

Answer 1

Try,

SELECT MODELLI.MOD_DESC, COUNT(MODELLI.MOD_DESC)
FROM VEGA.DISTRIB DISTRIB, VEGA.MODELLI MODELLI
WHERE DISTRIB.DIS_FLAG = 'M' AND DISTRIB.DIS_MOD = MODELLI.MOD_COD
GROUP BY MODELLI.MOD_DESC ORDER BY MODELLI.MOD_DESC

It will work as OP suggested..

Try this now..

Answer 2

You can use ORDER BY clause just after the GROUP BY clause like,

SELECT MODELLI.MOD_DESC, 
       COUNT(MOD_DESC)
FROM   VEGA.DISTRIB DISTRIB, 
       VEGA.MODELLI MODELLI
WHERE  DISTRIB.DIS_FLAG = 'M' 
AND    DISTRIB.DIS_MOD = MODELLI.MOD_COD
GROUP BY MODELLI.MOD_DESC
ORDER BY MODELLI.MOD_DESC;

Answer 3

SELECT MODELLI.MOD_DESC, COUNT(MOD_DESC)
FROM VEGA.DISTRIB AS DISTRIB, VEGA.MODELLI AS MODELLI
WHERE DISTRIB.DIS_FLAG = 'M' AND DISTRIB.DIS_MOD = MODELLI.MOD_COD
GROUP BY MODELLI.MOD_DESC
order by MODELLI.MOD_DESC ASC