Jump to content

Pinback

Members
  • Content Count

    2
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Pinback

  • Rank
    Newbie
  1. Pinback

    Summarise results

    Thx , you're right. But in this case this isn't the prob... As I described I need the sum of each single day of all days per month. I guess I need something like DISTINCT, JOIN and SUM..but I don't know how 😞
  2. Pinback

    Summarise results

    Hi, I want to summarise my monthly sales results per day (see Attachment). That's my current code: SELECT sum FROM tb WHERE year=selected_year AND month=selected_month ORDER BY day ASC But instead of showing each single sale I want to summarise all sales per day and show the total sum. How can I do this? THX Simon
×