本文主要介紹了Sybase數(shù)據(jù)庫Varchar類型的排序示例,具體內容請參考下文:
1> select * from idid order by 1
2> go
id
----
1
10
11
2
20
(5 rows affected)
1> select * from idid order by convert(integer,id)
2> go
id
----
1
2
10
11
20
(5 rows affected)
1>
1> select * from idid order by 1
2> go
id
----
1
10
11
2
20
(5 rows affected)
1> select * from idid order by convert(integer,id)
2> go
id
----
1
2
10
11
20
(5 rows affected)
1>