Re: Order by

You've got it wrong. The correct (and the simplest!) syntax goes as under:

select column_name / expression from table_name / view_name order by
column_name/expression;

You can get the full syntax of the SELECT statement from Oracle
documentation.

Rgds,
Rakesh Tripathi.

----- Original Message -----
From: "Dean Brandt" <[email protected]>
To: "Oracle" <[email protected]>
Sent: Monday, February 10, 2003 4:57 PM
Subject: [oracle] Order by


>
> Is this statement correct in Oracle:
>
> Select row
> From column
> order by random limit 1
>
> If not, what is the correct syntax?
>
> Thanks
>
> Dean Brandt
> Clever Thinking Consulting
> Network/Systems Integration,
> Application Design
> Melbourne, Australia
> 0418488885
> ...smart networks for smart business
>
>
> ---
> Change your mail options at http://p2p.wrox.com/manager.asp or
> to unsubscribe send a blank email to %%email.unsub%%.


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].