SELECT replicate('0',
10-len(ltrim(rtrim(convert(char(10),KeyID)))))+ltrim(rtrim(convert(char(10),KeyID)))
as TempID, * FROM TableA ORDER BY TempID
10 adalah contoh panjang maksimum dari KeyID jika doconvert ke dalam
string.Jadi bisa disesuaikan.
Demikian salah satunya. Smoga membantu.
--- On Sun, 12/6/09, Halomoan Chow <[email protected]> wrote:
From: Halomoan Chow <[email protected]>
Subject: [BinusNet] Tanya: SQL order by
To: [email protected]
Date: Sunday, December 6, 2009, 6:19 PM
Hi teman2 di Binusnet
Ada yg pernah mengalami kejadian sorting data seperti ini.
TableA
KeyID
1
2
3
10
SELECT * FROM TableA ORDER BY KeyID
Hasilnya:
KeyID
10
1
2
3
Bagaimana agar hasil query mengembalikan
1,2,3,10 ?
Trims
Halomoan
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
