KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am trying to figure out the proper syntax for getting query result I need. Here is the scenario: I am designing a SaaS application and have a table called trips, like so: table.trips - trip_id (pk, ai) - client_id (fk) - shop_id (fk) - trip_date (date) I need to be able to get the number of trips in the table for each day (by shop_id) and then deliver the number of TRIPS per trip_date, like: DATE | TRIP SUM -------------------------- 01-01-2011 | 3 01-02-2011 | 2 01-03-2011 | 5 Any thoughts on the proper syntax?
Tags (comma-separated)
Save Edits
Cancel