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.
Пікірлер: 64
@rks.siddhartha2 жыл бұрын
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!!
@ankitbansal62 жыл бұрын
Glad it helped you 😊
@ShriJi-Rasoi Жыл бұрын
That's the best explanation I found on lead and lag, thanks bro
@ankitbansal6 Жыл бұрын
Glad it helped
@ianpropst-campbell60282 жыл бұрын
This was a helpful demonstration of the lead and lag functions. Thank you!
@jannatbhengray165027 күн бұрын
Thank you so much, it made my topic crystal clear :-)
@adityeshchaturvedi65532 жыл бұрын
Short crisp and really informative!
@learnwithAashish2 жыл бұрын
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
@ankitbansal62 жыл бұрын
Sure
@lokeshsharma9386 Жыл бұрын
Thank you, I have got a job with 50% , I have learnt virtually from your videos, my concept got clear . Thank you so much
@ankitbansal6 Жыл бұрын
👌
@shubhammeshram85045 ай бұрын
Great. Very informative 😀.
@amitkushwah840111 ай бұрын
Really Good. Explained in the simplest way.
@sharans57712 ай бұрын
Excellent explanation, especially with real time scenario example
@ankitbansal62 ай бұрын
Glad it was helpful!
@dfkgjdflkg6 ай бұрын
As usual, great content. Excellent work. thank you
@minlin97052 жыл бұрын
It is well explained. The example is aweomse. Thank you, Ankit!!
@ankitbansal62 жыл бұрын
🙏
@DishantGupta-t3 ай бұрын
Helpful 👍
@ankitbansal63 ай бұрын
Glad it helped
@sivasuthan0042 жыл бұрын
Crisp and clear explanation!
@ankitbansal62 жыл бұрын
Thank you 😊
@gyan_chakra2 жыл бұрын
Awesome 😎👍.. such a lovely & simple explanation 😊
@mehmetkaya4330 Жыл бұрын
Thank you for the great examples!
@ankitbansal6 Жыл бұрын
Glad you like them!
@vikasvk91742 жыл бұрын
very informative video ... Thank you
@pavitrashailaja8502 жыл бұрын
Very neatly explained!
@ankitbansal62 жыл бұрын
Glad you liked it
@mdfurqan Жыл бұрын
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
@apexemperor Жыл бұрын
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?
@mdfurqan Жыл бұрын
@@apexemperor yes have implemented and working fine
@ankush_in_sync5998Ай бұрын
Love you sir, love you
@shankrukulkarni3234 Жыл бұрын
It really good if you can provide the dataset link so that we can practice simultaniously
@dfkgjdflkg6 ай бұрын
Look online, lots of datasets
@vikastyagi7811 Жыл бұрын
Crisp and clear
@anirudhupadhyay6952 жыл бұрын
Congratulations and thanks.
@ankitbansal62 жыл бұрын
Thank you 😊
@god_father007i5 ай бұрын
Thanks men it helps
@sreedharagandla2 күн бұрын
Hi ankit , Can u let me know super data where it is or can share the link pls so that we can prasctise . Thanks
@gazart8557 Жыл бұрын
Excellent
@ankitbansal6 Жыл бұрын
Thank you! Cheers!
@pavankumarchahar Жыл бұрын
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.
@PhysicsCoachAnkitSaraswat Жыл бұрын
do bring some more example question related to sql topics and provide data shert for practvie sir
@ankitbansal6 Жыл бұрын
Sure
@anamikachaudhary6814 Жыл бұрын
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.
@rashisingh82252 жыл бұрын
Please provide the create and insert query so that we can practice
@ankitbansal62 жыл бұрын
Rashi scripts are there in most the videos description box. Will fix if anyone is missing
@rashisingh82252 жыл бұрын
@@ankitbansal6 can you let me know in which video you have imported the data or share the link I cant find it
@ankitbansal62 жыл бұрын
@@rashisingh8225 You can check in description box only for individual videos
@shifanasheriff Жыл бұрын
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 ?
@pavan5208 Жыл бұрын
Create a YTD Flag first and use that as a filter?
@themightyvk Жыл бұрын
Thanks buddy...
@ankitbansal6 Жыл бұрын
Always welcome
@prasadchowdary48709 ай бұрын
Where we can download the superstore data
@riyalmasla8 ай бұрын
thank you
@ankitbansal68 ай бұрын
You're welcome
@ritikajaiswal38242 жыл бұрын
Can you make a video on the code which is different in different database like oracle, mysql workbench, postgresql, ms server?
@ankitbansal62 жыл бұрын
Sure
@harshupreti1526 Жыл бұрын
Why use sql when we have powerful tools like powerbi , tableau ? I am very curious and no way mean to disrespect . Please answer
@aayushibirla2590 Жыл бұрын
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.
@afonsoosorio2099 Жыл бұрын
@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.
@jasleenkaur-cw2fw Жыл бұрын
can you please provide the dataset?
@apexemperor Жыл бұрын
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 ❤
@ankitbansal6 Жыл бұрын
What exactly do you want to achieve from your scd2 table ?