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

Horana Colombo road construction begin

Hey my blog friends from Horana, here we have a good news Part of Colombo- Horana road(120 route) Kesbewa to Pamankada in the  will be developed at a cost of 3310 million rupees. The project will be initiated today(5th march,2013).  The Asian Development Bank provides loan facilities for this project. Construction will be completed within two years. The minister said that an alternative road from Kesbewa to Maharagama will also be laid parallel to that. Pamankada - Kesbewa section of Colombo - Horana Road (B084) The proposed road project, Colombo-Horana Road Section (B 084), commences from 0.520km near Pamankada Bridge in Colombo and terminates at the end of the bypass in Kesbewa at 13+400km. The regular Colombo-Horana (B 084) Road commences from Wilasitha Niwasa junction (0.00km) at Colombo-Ratnapura-,Batticaloa (A04) Road and terminates at Pokunuowita on Panadura-Ratnapura (A08)Road, before 2.0km to reach Horana town, traversing 28+180km. This road sect...
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