SQL> select empno, ename from emp;

EMPNO ENAME
---------- ----------
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE
7782 CLARK
7788 SCOTT
7839 KING
7844 TURNER
7876 ADAMS

EMPNO ENAME
---------- ----------
7900 JAMES
7902 FORD
7934 MILLER

14 rows selected.

SQL> select empno, ename from emp where empno >7780
2 ;

EMPNO ENAME
---------- ----------
7782 CLARK
7788 SCOTT
7839 KING
7844 TURNER
7876 ADAMS
7900 JAMES
7902 FORD
7934 MILLER

8 rows selected.

SQL>

SORTING

SQL> select empno, ename from emp;

EMPNO ENAME
---------- ----------
7369 SMITH
7499 ALLEN
7521 WARD
7566 JONES
7654 MARTIN
7698 BLAKE
7782 CLARK
7788 SCOTT
7839 KING
7844 TURNER
7876 ADAMS

EMPNO ENAME
---------- ----------
7900 JAMES
7902 FORD
7934 MILLER

14 rows selected.


SQL> select empno, ename from emp where empno > 7800 order by ename;

EMPNO ENAME
---------- ----------
7876 ADAMS
7902 FORD
7900 JAMES
7839 KING
7934 MILLER
7844 TURNER

6 rows selected.

SQL> select ename, empno from emp where empno > 7800 order by ename;

ENAME EMPNO
---------- ----------
ADAMS 7876
FORD 7902
JAMES 7900
KING 7839
MILLER 7934
TURNER 7844

6 rows selected.

SQL>

 DESCENDING OUTPUT DATA

SQL> select ename as "Full Name", empno as "ID"
  2  from emp
  3  where empno > 7800
  4  order by ename;

Full Name          ID
---------- ----------
ADAMS            7876
FORD             7902
JAMES            7900
KING             7839
MILLER           7934
TURNER           7844

6 rows selected.

SQL> select ename as "Full Name", empno as "ID"
  2  from emp
  3  where empno between 7500 and 7750
  4  order bgy ename desc;
order bgy ename desc
      *
ERROR at line 4:
ORA-00924: missing BY keyword


SQL> select ename as "Full Name", empno as "ID"
  2  from emp
  3  where empno between 7500 and 7750
  4  order by ename desc;

Full Name          ID
---------- ----------
WARD             7521
MARTIN           7654
JONES            7566
BLAKE            7698

SQL>