Re: order by question

From: Alan Shein <alanshein_at_erols.com>
Date: Mon, 13 Dec 1999 10:11:21 -0500
Message-ID: <8332ao$sle$1@autumn.news.rcn.net>

It should work. It works for me:

SQL> select * from test_table;

COL1

---

#1
1)
2)
#2
#3
3)

6 rows selected.

SQL> select col1 from test_table order by col1;

COL1

---

#1
#2
#3
1)

2)
3)

6 rows selected.

Frank Streitzig <Frank.Streitzig_at_T-Online.de> wrote in message news:8329tr$5jn$1_at_news02.btx.dtag.de...
> Hi,
>
> i have a order by question. I have a table x with one column t char(5).
The
> table contain 6 rows.
>
> #1
> 1)
> #2
> 2)
> #3
> 3)
>
> I like sort table (select t from x order by t), but receive no order.
> I like follow sorting:
>
> #1
> #2
> #3
> 1)
> 2)
> 3)
>
> Can anybody help me?
>
> Sorry for my language. :-)
>
> Frank Streitzig
> Germany
>
>
Received on Mon Dec 13 1999 - 09:11:21 CST