select id from table order by id;

解决方案 »

  1.   

    SQL> desc emp;
     名称                                                  是否为空? 类型
     ----------------------------------------------------- -------- ------------------
     EMPNO                                                 NOT NULL NUMBER(4)
     ENAME                                                          VARCHAR2(10)
     JOB                                                            VARCHAR2(9)
     MGR                                                            NUMBER(4)
     HIREDATE                                                       DATE
     SAL                                                            NUMBER(7,2)
     COMM                                                           NUMBER(7,2)
     DEPTNO                                                         NUMBER(2)SQL> select ename from emp order by ename;ENAME
    ----------
    ADAMS
    ALLEN
    BLAKE
    CLARK
    FORD
    JAMES
    JONES
    KING
    MARTIN
    MILLER
    SCOTT
    SMITH
    TURNER
    WARD已选择14行。已用时间:  00: 00: 00.01
    SQL>
      

  2.   

    哦,可能这样才是你的意思吧
    SQL> select to_number(sal) sal1 from emp order by sal1;     SAL1
    ---------
         1600
         1900
         2200
         2500
         2500
         2600
         3000
         3200
         4900
         5700
         5950
         6000
         6000
        10000已选择14行。已用时间:  00: 00: 00.00
    SQL>
      

  3.   


    应该是这样吧,首先应该把id 转换成数字再进行排序!!!
    select * from table order by to_number(id)
      

  4.   

    直接用
    select * from emp order by to_number(id);
    能出你要的结果吧