List:General Discussion« Previous MessageNext Message »
From:Chris Knipe Date:June 7 2002 4:28am
Subject:Re: How to sort on multiple columns?
View as plain text  
> > describe CL0420;
> > +----------+-------------+------+-----+---------+-------+
> > | Field    | Type        | Null | Key | Default | Extra |
> > +----------+-------------+------+-----+---------+-------+
> > | ID       | int(11)     | YES  |     | 0       |       |
> > | Producer | char(255)   | YES  | MUL | NULL    |       |
> > | Varietal | char(255)   | YES  | MUL | NULL    |       |
> > | Vineyard | char(255)   | YES  | MUL | NULL    |       |
> > | Year     | char(50)    | YES  |     | NULL    |       |
> > | Size     | char(255)   | YES  |     | NULL    |       |
> > | Average  | int(11)     | YES  |     | 0       |       |
> > | Sold     | smallint(6) | YES  |     | NULL    |       |
> > +----------+-------------+------+-----+---------+-------+
> >
> > I'd like to sort on Producer, Varietal, Vineyard
> >   (in that order)
>
> SELECT * FROM CL0420 ORDER BY Producer, Varietal, Vineyard;
>
> That *should* work ?

<query>


Thread
How to sort on multiple columns?Tim Johnson7 Jun
  • Re: How to sort on multiple columns?Victoria Reznichenko7 Jun
Re: How to sort on multiple columns?Chris Knipe7 Jun