scott_ttocs46 Posted September 21, 2008 Share Posted September 21, 2008 Hi All, I need an SQL statement that will sort t-scores where 1.000 is the perfect score. That is 0.999 is more of a match than 1.112. It is not necessarily linear. I am really stumped. Any ideas ??? Scott Link to comment https://forums.phpfreaks.com/topic/125190-sql-sort-a-t-score/ Share on other sites More sharing options...
Mchl Posted September 21, 2008 Share Posted September 21, 2008 So, the closer to 1.000 the better? SELECT rowID, score, ABS(1 - score) AS match ORDER BY match ASC Link to comment https://forums.phpfreaks.com/topic/125190-sql-sort-a-t-score/#findComment-647164 Share on other sites More sharing options...
scott_ttocs46 Posted September 21, 2008 Author Share Posted September 21, 2008 Yes. Thanks. I will test it. Link to comment https://forums.phpfreaks.com/topic/125190-sql-sort-a-t-score/#findComment-647191 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.