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 Quote 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 Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.