3 Replies Latest reply: Nov 19, 2012 5:44 AM by 945595 RSS

    Problem with order by clause

    945595
      Hai all,

      I have problem with order by clause,

      My query is

      "select number from table1 order by number asc "

      and the output is displaying as

      1
      10
      12
      13
      15
      17
      19
      2
      20
      21
      22
      .
      ........

      But if we give order by it should display as below only right ?

      1
      2
      10
      12
      13
      15
      17
      19
      20
      21
      22 ........

      Please help me why it is not displaying like it. and how to make the statement to display like the second case. Thanks in advance.

      Regards,
      Uraja