Re: SQL

How about:

select type,max(count(titles.type))
from titles
group by titles.type

Sandra Calisto wrote:
>
> Hi!
>
> I'm with a problem! Can you help me?
> Well ... imagine that you have a bookstore database and want to know
> wich type of book (science, literature, etc) has more books!!!
> Well I did the counting ...
> select type, count (titles.type)
> from titles
> group by titles.type
> My prob is ... how do I get the greatest type of book!
> Can you help me, please?
>
> Sandra

       The contents of this message express only the sender's opinion.
       This message does not necessarily reflect the policy or views of
       my employer, Merck & Co., Inc.  All responsibility for the statements
       made in this Usenet posting resides solely and completely with the
       sender.