vendredi 31 juillet 2015

How do i split date with a wher clause in SQLite?

I have a database that is a list of all transactions done by employees. The table contains the transaction ID, Employee_ID, and terminal. I need to return a single query that will list the number of transactions done in each section of the store. (i.e. terminals 1-4, 5-10). I need to look up how many transactions John Smith did on terminals 1-4 and how many he did on terminals 5-10.

Aucun commentaire:

Enregistrer un commentaire