Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.alt.net!news.usenetgateway.com!not-for-mail From: sandijs Newsgroups: comp.databases.oracle.server Subject: Re: And the correct answer is? Date: Fri, 04 Apr 2003 12:00:58 +0000 Organization: dBforums Lines: 26 Sender: sandijs Message-ID: <2729051.1049457658@dbforums.com> References: <3E8E0B9E.B0B9251F@noway.org> User-Agent: dBforums X-Original-NNTP-Posting-Host: dbforums.com X-Original-Trace: 4 Apr 2003 07:18:13 -0500, dbforums.com X-Authenticated-User: paul Xref: newsfeed1.easynews.com comp.databases.oracle.server:181974 X-Received-Date: Fri, 04 Apr 2003 05:17:57 MST (news.easynews.com) You are wrong here. When you say "ORDER BY 1" it means you want to order by first column of resultset and "ORDER BY 2" = order by second column and so on. Sandijs OCP DBA, Riga, Latvia Originally posted by Mikito Harakiri > "1" is just a constant function (or constant expression), so that > > SELECT empno, ename FROM emp ORDER BY 1 > > must be equivalent to > > SELECT empno, ename FROM emp ORDER BY 2 > > and to just > > SELECT empno, ename FROM emp -- Posted via http://dbforums.com