Re: Selecting

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Thu, 31 Aug 2000 15:17:27 -0700
Message-ID: <8omldv$sbp$1@spiney.sierra.com>

select category, subcategory
from <table>
group by category, subcategory
/

"Bhavin Shah" <bhavinsh_at_aludra.usc.edu> wrote in message news:Pine.GSO.4.21.0008311037580.15367-100000_at_aludra.usc.edu...
> Hi,
>
> Say I have a table setup like the following:
>
> Category Subcategory
> ------------------------
> USA CA
> MEXICO
> USA AZ
> USA CA
>
>
> Is there a way to select the category only once and
> then get the list of subcategories with it?
> Right now I'm using select distinct category, subcategory
> from X, but am getting USA multiple times like
>
> -------------------
> USA CA
> USA AZ
> MEXICO
>
> What I would like is:
>
> --------------------
> USA CA
> AZ
> MEXICO
>
>
>
> TIA,
>
> Bhavin
>
>
Received on Thu Aug 31 2000 - 17:17:27 CDT