Re: simple answer not obvoius to me, Newbie help.

Great!!!!!!!!!!!!!!!!!!!

Thanks Lads, I'll toast you on Friday night!

pat

Myron Wintonyk <mwintony_at_med.ualberta.ca> wrote in message news:3A6E3798.7065DBE7_at_med.ualberta.ca...
> OOpps ... I'm sure it was just a typo, but the syntax is
>
> select the list of fields from your_table ORDER BY price desc;
>
> i.e. select part_number, description, price from parts order by prics
 desc;
>
>
> Jim Kennedy wrote:
>
> > select the list of fields from your_table where price desc;
> >
> > (assuming price is a numeric variable and not a character or varchar)
> > Jim
> > "MadG" <patrick4133_at_hotmail.com> wrote in message
> > news:hiqb6.228998$59.58197264_at_news3.rdc1.on.home.com...
> > > Hi,
> > >
> > > I am trying to display the table in descending order by price but I
 can't
> > > get the syntax right.
> > >
> > > Can any one help?
> > >
> > > Thanks in advance:)
> > >
> > > Patrick
> > >
> > >
>
Received on Tue Jan 23 2001 - 20:12:26 CST