SQL Query | Compare monthly sales with previous month, same month previous year, first month of year

No video

SQL Query | Compare monthly sales with previous month, same month previous year, first month of year

Рет қаралды 49,818

Күн бұрын

In this video, we write a SQL to compare monthly sales -
1) With previous month
2) same month previous year
3) first month of year
Check out the complete list of SQL Query Interview Questions -
• SQL Query Interview Qu...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - learn@knowstar.org

Пікірлер: 64

@LearnatKnowstar 3 жыл бұрын

Are you interested in attending an online SQL training course? We have received a few inquiries and are now planning one on 18 and 19 September 2021. This will be a 10 hours instructor led training covering SQL concepts as well as practical SQL query writing. The training cost is USD 100. If you are interested, please register here - forms.gle/y2U2eKmShq6JUnc29 Thank you 🙂

@mihirforyou3531 3 жыл бұрын

Mam what are the topics will be covered?

@NareskanthM Ай бұрын

thanks sister ! very easy to understand !

@LearnatKnowstar 18 күн бұрын

Glad it was helpful!

@tlubaina 2 жыл бұрын

You just saved my semester! Thanks

@LearnatKnowstar 2 жыл бұрын

Thank you

@chandudevarapu1578 3 жыл бұрын

Thank you mam... Nice explained pls upload more videos like that... I will refer my friends also this type of scenarios very useful for us

@LearnatKnowstar 3 жыл бұрын

Thanks so much. Do make sure that you and your friends subscribe to the channel 🙂

@surajpatil3579 2 жыл бұрын

Thanks mam, splendid explanation keep making content like this!!

@NareskanthM 2 ай бұрын

Great Explanation !

@mummz3371 2 жыл бұрын

I love watching your content because of the practical examples you use, thank you ❤️

@LearnatKnowstar 2 жыл бұрын

Thank you

@MokshDrar Жыл бұрын

@@LearnatKnowstar Thanks maam you are very smart

@pravinm1490 10 ай бұрын

very nicely explained

@LearnatKnowstar 10 ай бұрын

Thank you so much 🙂

@deepthimurali962 Жыл бұрын

Can you suggest how to use lag and offset if we want to compare Jan-Feb 2022 vs Jan-Feb 2023. I basically want to sum both jan and feb and compare the growth Thanks for this!

@mihirforyou3531 3 жыл бұрын

Thank you Mam ... very useful.. nicely explained ☺️

@LearnatKnowstar 3 жыл бұрын

Thank you so much!

@jashanpreetsingh4750 2 жыл бұрын

Thanks a lot . Exactly solved the query i was having.

@LearnatKnowstar 2 жыл бұрын

Thank you 🙏

@pravinm1490 10 ай бұрын

Nicely explained

@LearnatKnowstar 10 ай бұрын

Thank you so much 🙂

@saktibiswal6445 Жыл бұрын

Awesome explanation of LAG & OFFSET. Thanks!!

@LearnatKnowstar Жыл бұрын

Glad it was helpful!

@ajeshrajan8079 Жыл бұрын

Good explanation

@LearnatKnowstar Жыл бұрын

Thank you

@brianducharme3418 2 жыл бұрын

Thank you so very much!!

@LearnatKnowstar 2 жыл бұрын

Glad it helped!

@nikolaybaranov2213 2 жыл бұрын

Great explanation of how window functions work!

@LearnatKnowstar 2 жыл бұрын

Thank you

@Regc10 Жыл бұрын

This is amazing helped me alot.

@LearnatKnowstar Жыл бұрын

Glad it was helpful.

@thatssodinesh7857 Жыл бұрын

You're great! Thank you so much

@LearnatKnowstar Жыл бұрын

Thank you!

@BGK8 3 жыл бұрын

Excellent video series. Take a bow!! Could you please make something like this in Stored procs, performance tuning concepts

@LearnatKnowstar 3 жыл бұрын

Thanks so much. Sure, we will be posting videos on advanced topics in near future.

@kesavanandt1195 2 жыл бұрын

Good explanation madam...thank you very much. And mam, what modification is to be done in this query to get the next month sales.??

@LearnatKnowstar 2 жыл бұрын

Thank you. You can use the LEAD function instead of the LAG function

@pupu41784 2 жыл бұрын

Thank you so much. I needed this! :D

@LearnatKnowstar 2 жыл бұрын

Glad it was helpful.

@jadeldeek5100 2 жыл бұрын

is possible to have monthly figures or yearly figures by columns not by row as your example? YEAR 1, YEAR 2 OR JAN, FEB , MARS ....

@Tech2BI 3 жыл бұрын

As long as it's 2017 or higher versions we have functions for the same scenarios for previous versions like 2012 or 2008 r2 do you have any solution for this?

@satyapalrawat7857 Жыл бұрын

Hi - this is very helpful. But what if there is a month missing in the last year data ?

@oladman9058 11 ай бұрын

Wow!

@jonnybrooks97 Жыл бұрын

How can you drill down into specific columns with this, for example if you wanted to look at month on month changes for each store or region?

@tigerdataimarticus7088 2 жыл бұрын

I have a query: if current month total production from 1st date to current date then how can we calculate previous month production total with current month date range

@sivachaitanya6330 Жыл бұрын

month(date) inside lag() function is throwing error says month should not be here in mysql ................what is the solution.........lag(sum(amount),Month(date))-------------->ERRor?????????????????

@balamuralibattala3283 Жыл бұрын

Hi everyone,How to find the company that has growth in three successive years.pls provide solution for it

@rohitwaregaonkar3703 Жыл бұрын

Write a stored procedure that accepts the month and year as inputs Please help

@ankurranjan3218 2 жыл бұрын

Let suppose Data does not have consecutive months data. For example I am having 2020-01 and 2020-06 data only then If I am comparing with previous month using LAG then it will not be correct, right? As it will compare June from Jan but I wanted to compare only June from May. How to proceed for this type of scenrio.

@pranavnair8977 2 жыл бұрын

use cross join