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

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 - 19:56:06 CST