Lead/Lag Window Analytical functions in SQL | Advance SQL concepts
HTML-код
- Опубликовано: 10 фев 2022
- In this video we will learn lead/lag analytical functions. these functions are used when you need to compare current row with another previous or next row. Very important for interview preparation as well.
This was a helpful demonstration of the lead and lag functions. Thank you!
Short crisp and really informative!
Really Good. Explained in the simplest way.
As usual, great content. Excellent work. thank you
Awesome 😎👍.. such a lovely & simple explanation 😊
Great. Very informative 😀.
That's the best explanation I found on lead and lag, thanks bro
Glad it helped
very informative video ... Thank you
I always get confused with the combination of lead/lag and order by in the over clause which lead to couple of tries to get the desired output, faced similar confusion today and searched your channel for the these functions. Thank you for covering exactly what I was looking for!!
Glad it helped you 😊
It is well explained. The example is aweomse. Thank you, Ankit!!
🙏
Crisp and clear explanation!
Thank you 😊
Thank you for the great examples!
Glad you like them!
Crisp and clear
Thanks for your valuable knowledge Sharing. Although I learned SQL but everytime I came here , always feel I know nothing.
Keep Good work going 👍 & also if possible please start sharing your knowledge on Python it will be very helpful.
Thanks
Sure
Thanks men it helps
Very neatly explained!
Glad you liked it
Thank you, I have got a job with 50% , I have learnt virtually from your videos, my concept got clear . Thank you so much
👌
Excellent explanation, especially with real time scenario example
Glad it was helpful!
Congratulations and thanks.
Thank you 😊
Love you sir, love you
Hi Ankit,
I am using history table where create_dt is the indicator for comparison between 2 rows, I have used this lag logic to generate scd2 on my history table. Thanks
Hi... I am also probably looking for the same thing . I have a table which has Scd2 records and the last active records ends with high end dt something like 2200-01-01
Do u think this logic will work with some twigs ofcourse?
@@apexemperor yes have implemented and working fine
Helpful 👍
Glad it helped
Order_date column is in text format , maybe that is why it is giving me null select month(order_date) from superstore data table. Can you please suggest why is this happening. it pull null values for me. I am using MySQL workbench and when I use select EXTRACT(MONTH FROM Order_Date) as month from superstore_orders; it pulls null values for all the columns . Can someone help please.
It really good if you can provide the dataset link so that we can practice simultaniously
Look online, lots of datasets
do bring some more example question related to sql topics and provide data shert for practvie sir
Sure
Excellent
Thank you! Cheers!
Where we can download the superstore data
Hi Ankit ,
What change should do in the query
If I want to see the sales of same period last year till the date
(YTD previous year)? Can you help ?
Create a YTD Flag first and use that as a filter?
Thanks buddy...
Always welcome
Suppose we have the YEAR, Revenue column but the year is 2012, 2015, 2016, 2017, and 2019 then this case how to calculate the missing default year 0 and subsequent.
Can you make a video on the code which is different in different database like oracle, mysql workbench, postgresql, ms server?
Sure
thank you
You're welcome
can you please provide the dataset?
Please provide the create and insert query so that we can practice
Rashi scripts are there in most the videos description box. Will fix if anyone is missing
@@ankitbansal6 can you let me know in which video you have imported the data or share the link I cant find it
@@rashisingh8225 You can check in description box only for individual videos
Why use sql when we have powerful tools like powerbi , tableau ? I am very curious and no way mean to disrespect . Please answer
SQL is used for storing and retreiving data from database. Power BI and tablaeu are the data visualization tools. Here we just load data and make visualizations from it.
@Harsh, that is a valid and legitimate question. I had the very some concern but after doing some training in SQL, now I understand that it is a must skill to command in data analytics.
You are absolutely right there are powerful data analysis tools such as power query, power BI, Python and R.
We need SQL because is where we will often get plain raw data stored in multiple related tables (RDBMS).
So we have to query and retrieve the subset or dataset we are interested in for detailed analysis using those powerful data analysis tools.
Hardly you will get stored in spreadsheet and tabular format like Excel, or CSV and ready for analysis.
In a nutshell, we need SQL for extracting datasets from database and then transform and get loaded in a powerful data analysis tool.
Hi... I am also probably looking for the same thing . I have a table which has Scd2 records and the last active records ends with high end dt something like 2200-01-01
Do u think this logic will work with some twigs ofcourse?
Came across your channel yesterday and there are lot of things to learn ❤
What exactly do you want to achieve from your scd2 table ?