Order by datetime

[pem.git] / pem

diff --git a/pem b/pem
index 6127363612a512dd4c43923921101c6f7a2363eb..29392ec7557b68ede09b18919a9977295c8bd58e 100755 (executable)
--- a/pem
+++ b/pem
@@ -55,7 +55,8 @@ s)
         FROM expenses
         LEFT JOIN m2m ON m2m.expense_id=expenses.id
         LEFT JOIN tags ON m2m.tag_id=tags.id
-        GROUP BY expenses.id"
+        GROUP BY expenses.id
+        ORDER BY dt DESC"
     ;;
 t)
     $SQLITE -column -header $DB "