Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: simple answer not obvoius to me, Newbie help.
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:02:00 CST