SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table input ( numbers real);
✓
insert into input values ('-Infinity'),('+Infinity'),('NaN'),(2),(0) ,(5);
✓
select * from input
order by numbers


numbers


0

2

5

+Infinity

-Infinity

NaN