Re: ORDER BY 1

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Sat, 3 Aug 2002 15:47:10 +1000
Message-ID: <aifr0f$sq4$1@lust.ihug.co.nz>

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

SQL> select * from emp order by 1;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- -

         8 HARRIS                                          1234
      7369 SMITH      CLERK           7902 17/DEC/80       1234
20
      7499 ALLEN      SALESMAN        7698 20/FEB/81       1234        300
30
      7521 WARD       SALESMAN        7698 22/FEB/81       1234        500
30
      7566 JONES      MANAGER         7839 02/APR/81       1234
20
      7654 MARTIN     SALESMAN        7698 28/SEP/81       1234       1400
30
      7698 BLAKE      MANAGER         7839 01/MAY/81       1234
30
      7782 CLARK      MANAGER         7839 09/JUN/81       1234
10
      7788 SCOTT      ANALYST         7566 19/APR/87       1234
20
      7839 KING       PRESIDENT            17/NOV/81       1234
10
      7844 TURNER     SALESMAN        7698 08/SEP/81       1234          0
30
      7876 ADAMS      CLERK           7788 23/MAY/87       1234
20
      7900 JAMES      CLERK           7698 03/DEC/81       1234
30
      7902 FORD       ANALYST         7566 03/DEC/81       1234
20
      7934 MILLER     CLERK           7782 23/JAN/82       1234

15 rows selected.

SQL> select * from emp order by 2;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- -

7876 ADAMS CLERK 7788 23/MAY/87 1234 20

7499 ALLEN SALESMAN 7698 20/FEB/81 1234 300 30

7698 BLAKE MANAGER 7839 01/MAY/81 1234 30

7782 CLARK MANAGER 7839 09/JUN/81 1234 10

7902 FORD ANALYST 7566 03/DEC/81 1234 20

         8 HARRIS                                          1234
      7900 JAMES      CLERK           7698 03/DEC/81       1234
30
      7566 JONES      MANAGER         7839 02/APR/81       1234
20
      7839 KING       PRESIDENT            17/NOV/81       1234
10
      7654 MARTIN     SALESMAN        7698 28/SEP/81       1234       1400
30
      7934 MILLER     CLERK           7782 23/JAN/82       1234
10
      7788 SCOTT      ANALYST         7566 19/APR/87       1234
20
      7369 SMITH      CLERK           7902 17/DEC/80       1234
20
      7844 TURNER     SALESMAN        7698 08/SEP/81       1234          0
30
      7521 WARD       SALESMAN        7698 22/FEB/81       1234        500

As you can see, the first example sorts by EMPNO, the second by ENAME.

Regards
HJR "Stjepan Brbot" <stjepan.brbot_at_zg.hinet.hr> wrote in message news:aifov1$3c8u$1_at_as201.hinet.hr...
> What kind of ordering it is when there is "ORDER BY 1" in SELECT
> SQL-statement?
>
> --
>
> Stjepan Brbot
>
>
>
Received on Sat Aug 03 2002 - 00:47:10 CDT