MYSQL, why ORDER BY DESC fails but ORDER BY ASC works?
Why is only one of these queries working?
Works:
SELECT *
FROM `global_rank`
WHERE rank_type = 2
AND rank < 1531.26367188
AND id <> 103
ORDER BY rank ASC
Failure (i.e. returns 0 rows):
SELECT *
FROM `global_rank`
WHERE rank_type = 2
AND rank < 1531.26367188
AND id <> 103
ORDER BY rank DESC
+3
source to share
2 answers