sql Query to Group By Year, Month, Week, Day

I tried to make a report to see a list of total records, grouped by month:


Which i found from articles:

SELECT Sum(someValues) 
FROM Table 
GROUP BY Year(date_feild), Month(date_feild), Day(date_feild) 


what i wrote first:

select count(*),Year(entered_on) ,Month(entered_on)
 from receipt_table
group by 2,3


I end up with:

select Year(entered_on) as Year,Month(entered_on) as Month,count(*)
 from receipt_table
group by 1,2
order by 1,2


any comments guys?

Comments

Post a Comment

Popular posts from this blog

MDK Hospital opened in Horana

Image
Horana is getting a brand new private hospital! The M.D.K Healthcare Center & Hospital has just opened its doors on Anguruwathota Road, right next to the HNB bank branch. For years, many had to travel to Colombo for certain medical treatments, but hopes with new private hospital this will change. This new hospital, built by local businessman Mr. M.D. Piyananda Kularathna, comes with all the modern medical equipment we've been hoping for. It's wonderful to see such a major investment in Horana community's health. To makes this even better, I hope they have brought in highly skilled doctors and medical staff. No more long trips to Colombo for routine treatments! The hospital looks quite impressive too - modern and clean, just what you'd expect from a proper healthcare centre. The location is perfect as well. Being on Anguruwathota Road means it's easy to find and get to, whether you're coming from the town centre or surrounding areas. I've already notice...
Read more

Flyway in Spring Boot and Gradle: flyway-core vs Flyway Gradle Plugin

 Have you ever wondered about the best way to integrate Flyway into your Gradle project? Let me break it down into two main approaches: using Flyway as a dependency and applying the Flyway plugin . The Dependency Approach: implementation 'org.flywaydb:flyway-core' Adding Flyway as a dependency essentially embeds it within your application. Think of it as equipping your application with a built-in toolbox to handle database changes during runtime. This approach is ideal when you want your application to take charge of migrations. When to Use It Your application needs to manage database changes while it’s running. You’re working with a Spring Boot application that integrates seamlessly with Flyway. Key Features Spring Boot Auto-Configuration: Spring Boot automatically detects the Flyway dependency and configures it. You can custo...
Read more

Use of Sidecars to Microservice Communication

 Recently I attended Analysis Design Architcture conference (https://adaconf.org/) where listened to talk named "Future Proof Software Architecture: Microservices". That reminded me my experience of using sidecars as part of a microservice architecture in one of my previous projects( Australian Bank). So I decided to write down some of the key points and insights that came out of that experience.  firstly, let's start with understanding why we might want to move beyond traditional API gateways. API gateways traditionally handle everything from TLS termination to authentication, authorisation, and traffic routing. They're like the swiss army knife of API management - doing lots of things in one place. But here's the problem - as our microservices architectures grow more complex, having all these responsibilities in a central gateway becomes a bottleneck. So let's see what are sidecars - think of them as your microservice's personal assistant. Instead of rou...
Read more