SQL
From: Sandra Calisto <sandracalisto_at_mail.telepac.pt>
Date: 1998/12/10
Message-ID: <74okm6$8jv$1_at_duke.telepac.pt>#1/1
Date: 1998/12/10
Message-ID: <74okm6$8jv$1_at_duke.telepac.pt>#1/1
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 ...
Sandra
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?