Re: ORDER BY 1

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 03 Aug 2002 08:46:04 +0200
Message-ID: <vsumkug0cmi715rr6mv1turjhe3639pi1l@4ax.com>

On Sat, 3 Aug 2002 15:47:10 +1000, "Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote:

>It *should* mean 'order by the first column of the table':

Sorry to say so, but this is incorrect.
order by n means : order by the <n>th *expression* in the select list, NOT by the <n>th *column* in the table.
Please run
select ename||'!', empno from emp
order by 1

By which expression does it order?

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Aug 03 2002 - 01:46:04 CDT