Re: Selecting

Thanks, but this still returns duplicate categories (ie) USA CA

     USA AZ
I was looking for:

     USA CA
         AZ

On Thu, 31 Aug 2000, Steve McDaniels wrote:

> 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 - 20:07:55 CDT