Re: SQL
From: clifford buetikofer <clifford_buetikofer_at_merck.com>
Date: Thu, 10 Dec 1998 09:46:20 -0500
Message-ID: <366FDEBC.D36ABED2_at_merck.com>
Date: Thu, 10 Dec 1998 09:46:20 -0500
Message-ID: <366FDEBC.D36ABED2_at_merck.com>
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.Received on Thu Dec 10 1998 - 15:46:20 CET