I needed to count the number of records in a table I use for tracking tasks within an SQLite database. The table is named "Tasks" and, in addition to other columns has a Received column, where I record when I received a task and an Approved column, where I record the date I approved the task. If I only want to see the task numbers and the dates on which I received and approved tasks and I want the records ordered by approval date, I can use the following Structured Query Language (SQL) command:
sqlite> select Task, Received, Approved from Tasks ORDER BY Approved; TAS000000204813|2016-04-20| TAS000000160855|2016-06-09| TAS000000302389|2016-06-08| TAS000000289579|2016-05-04|2016-05-06 TAS000000297385|2016-05-11|2016-05-11 TAS000000294896|2016-05-04|2016-05-12 TAS000000294136|2016-05-04|2016-05-12 TAS000000291991|2016-05-04|2016-05-13 TAS000000289882|2016-05-10|2016-05-13 TAS000000293978|2016-05-04|2016-05-16 TAS000000262109|2016-05-18|2016-05-19 TAS000000293289|2016-05-24|2016-05-24 TAS000000300934|2016-05-18|2016-05-24 TAS000000192984|2016-05-20|2016-05-24 TAS000000268274|2016-05-19|2016-05-24 TAS000000280549|2016-05-24|2016-05-24 TAS000000289548|2016-05-18|2016-05-24 TAS000000291959|2016-05-24|2016-05-24 TAS000000293970|2016-05-26|2016-05-26 TAS000000280569|2016-05-31|2016-05-31 TAS000000297347|2016-05-31|2016-05-31 TAS000000283262|2016-06-01|2016-06-07 TAS000000304021|2016-06-01|2016-06-07 TAS000000311853|2016-06-01|2016-06-07 TAS000000311293|2016-06-01|2016-06-07 TAS000000312411|2016-06-08|2016-06-08 TAS000000309299|2016-06-09|2016-06-09 TAS000000270128|2016-06-09|2016-06-09 TAS000000255397|2016-06-13|2016-06-13 TAS000000295302|2016-06-09|2016-06-14 TAS000000299922|2016-06-08|2016-06-14 TAS000000298570|2016-06-14|2016-06-14 TAS000000315505|2016-06-08|2016-06-14 sqlite>
I can count all of the records in the table with the SQL command below:
sqlite> select COUNT(*) FROM Tasks; 33 sqlite>
Within the table, I have a field named "Approved" that I use to track the approval date for tasks; I store the date as a text field, since SQLite doesn't have a storage class specifically for dates. If I want to know how many tasks I've approved since a specific date, I can use a command like the one below to determine the number approved since the specified date.
sqlite> select COUNT(*) FROM Tasks WHERE Approved > "2016-06-07"; 8 sqlite>
[ More Info ]
