$ sqlite3 database.sqlite
SQLite version 3.7.2
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table data ( datum real );
sqlite> .sch
CREATE TABLE data ( datum real );
sqlite> insert into data values ( 2.5 );
sqlite> insert into data values ( 2.52 );
sqlite> insert into data values ( 2.66 );
sqlite> insert into data values ( -9999 );
sqlite> insert into data values ( -9999 );
sqlite> insert into data values ( -9999 );
sqlite> select * from data;
2.5
2.52
2.66
-9999.0
-9999.0
-9999.0
sqlite> select * from data order by datum asc limit 2;
-9999.0
-9999.0
sqlite> select * from data order by datum asc;
-9999.0
-9999.0
-9999.0
2.5
2.52
2.66
sqlite>