Tipe utk field KeyID apa ya ?

Tq


--- On Mon, 12/7/09, Halomoan Chow <[email protected]> wrote:

From: Halomoan Chow <[email protected]>
Subject: [BinusNet]  Tanya: SQL order by
To: [email protected]
Date: Monday, December 7, 2009, 9:19 AM







 



  


    
      
      
      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]

Kirim email ke