clear markdown compare help best fiddles feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3601395 fiddles created (48036 in the last week).

CREATE TABLE dbo.tbl_Prueba ([Valor] numeric(10,4)) ;
 hidden batch(es)


INSERT INTO dbo.tbl_Prueba ([Valor]) VALUES (2.34), (5.89), (8.22) ;
3 rows affected
 hidden batch(es)


SELECT CAST(Valor as float) Valor FROM dbo.tbl_Prueba ORDER BY Valor - CONVERT(INT,Valor);
Valor
8.22
2.34
5.89
 hidden batch(es)