SQL

From: Sandra Calisto <sandracalisto_at_mail.telepac.pt>
Date: Thu, 10 Dec 1998 14:10:06 +0100
Message-ID: <74okm6$8jv$1_at_duke.telepac.pt>

    Hi!

[Quoted]     I'm with a problem! Can you help me? [Quoted] [Quoted]     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 Received on Thu Dec 10 1998 - 14:10:06 CET