$ 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>