SQLite Forum

How do I sort my Safari History.db History by DATE?
Adding to Ryan's helpful response: Once you have the database open in the SQLite \[sic\] shell, enter the command ".schema" (sans quotation marks) to see what the columns are named. Then, after perusing the [SELECT syntax](https://sqlite.org/lang_select.html), and the ORDER BY clause in particular, you will be close to getting an answer to the question you meant to ask.