This discussion is archived
3 Replies Latest reply: Nov 19, 2012 3:44 AM by 945595 RSS

Problem with order by clause

945595 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points