Mroberti's List: Database

• $ sqlite3 test.db  SQLite version 3.0.8  Enter ".help" for instructions  sqlite> .quit  $
• where exam=1 order by score desc limit 1;
• [WHERE expr]  [GROUP BY expr-list]  [HAVING expr]  [compound-op select]*  [ORDER BY sort-expr-list]  [LIMIT integer [( OFFSET | , ) integer]]

1 more annotation...