Very Computer

I have a problem with sorting on aggregate functions in Delphi, like this:

        SELECT Name, Count(ID)
        FROM tblTable
        ORDER BY ?!?!?

How do I order by Count(ID)?!?

Thanks,
--Lars M.

_______________________________________________________________________________

        Lars Marius Garshol

        "Life is a *ly transmitted disease", Andre Brink
        http://www.veryComputer.com/~larsga

Quote:>I have a problem with sorting on aggregate functions in Delphi, like this:

>    SELECT Name, Count(ID)
>    FROM tblTable
>    ORDER BY ?!?!?

>How do I order by Count(ID)?!?

Quote:>Thanks,

-----------------------
Pekka Haapalainen
e-mail: alpo<at>iki.fi
homepage: http://www.iki.fi/alpo/

On Thu, 23 Jan 1997 20:48:10 -0500, Bernard Hamaoui

-----------------------
Pekka Haapalainen
e-mail: alpo<at>iki.fi
homepage: http://www.iki.fi/alpo/

|> >

|> > >
|> > > I have a problem with sorting on aggregate functions in Delphi, like this:
|> > >
|> > >         SELECT Name, Count(ID)
|> > >         FROM tblTable
|> > >         ORDER BY ?!?!?
|> > >
|> > > How do I order by Count(ID)?!?
|> > >
|> > > Thanks,
|> > > --Lars M.
|> >
|> > Hi Lars,
|> > create view...(if it sql db) and select from it
|> > try:
|> >
|> > Select Name, Count(ID) as CountID
|> > from tblTable
|> > group by Name
|> > order by CountID
|> >
|> > Regards, Bernard (Montreal)

 mejor..

 SELECT Name, COUNT(ID)
 FROM tblTable
 ORDER BY 2;

   Regards ,
 Esteban Astudillo V (Santiago de Chile)

--
 E S T E B A N >> (ESTE)
 ---------------------------+
 <http://www.dcc.uchile.cl> |  ... la vida ...                          |