sql simple question about a query
I want to know if it's possible to put "ORDER BY" and "GROUP BY" in the
same query (without UNION)?
Re: sql simple question about a query
SELECT stor_id, SUM(qty) AS TotalSold
GROUP BY stor_id
ORDER BY stor_id
Michael Levy MCSD, MCDBA, MCT
"Rodolphe Pomerleau" <firstname.lastname@example.org> wrote in message
> I want to know if it's possible to put "ORDER BY" and "GROUP BY" in the
> same query (without UNION)?
> Thank you
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center