Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2009

    Unanswered: Fetch rows with timestamp within a week range

    I'm working with a fairly large query that fetches all rows in a database that have a timestamp occuring during a particular week. Within that query, I want to fetch the SUM of all returned rows that occur on a particular day (Monday, Tuesday, etc).

    Is there a nice, clean way of handling this sort of thing, or should I split the operation into multiple queries, or sub-queries?

  2. #2
    Join Date
    Mar 2004
    fetch using your start and end dates, group by dayofweek.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts