Actually it is not about how the functions work as they work both in exactly same way, the confusion is caused by how the ORDER BY clause within window function changes the data frames which are being taken to the functions to calculate the result for each row.
Hello Ankit, Thank you for making such insightful videos. I want to ask a question here. I have come across in a lot of interviews that they ask to solve a question without using a window function. Is there any trick to solving such questions? Can you provide us with an example.
At 7:39 ...why you again added order by emp_age at end of query even though you used order by in OVER clause. Even if you didn't add order by at the end the output looks same right
Hello Ankit, We can also use Join by 'using' keyword. For suppose, generally we write join like : a join b on a.id=b.id So by using keyword we can write like: a join b using id So many of them don't know that 'Using' keyword. Can you please make a video on it. And yeah i had used that first_value and last_value function
Yet another great video Ankit. Just a doubt I had in the frame clause : last_value(emp_name) over(order by emp_age rows between current row and unbounded following) last_value(emp_name) over(order by emp_age rows between unbounded preceding and unbounded following) Both above frame clauses give same results, right?
In the LAST_VALUE function..you used ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING.....does this work on WINDOW FUNCTION we use or both on ORDER BY and WINDOW FUNCTION we have used?
Good to know the difference between first and last value.
Thanks a lot sir🙏
Keep watching
Make video on different functions, like COALESCE, EXIST, INTERVAL, CONCAT, EPOCH etc
you are right .....
Whenever I watch your video I really Learn New Things Thankyou Sir❤❤
The perfect explanation which I was searching till date over the internet reg the issue with Last Date func !! Thank you 😀😀
Great to hear!
I learn something new today. Thanks for this. It is really helpful
Glad it was helpful!
Sir,It would be great if you take a SQL query where we have to make use of these functions.
Next video
Thank for providing script in description Ankit.
Also kindly try to do atleast 3videos per week . Just a request.
Thank you
I will try my best
@@ankitbansal6 thank you
Bahot achche !
Awesome explanation! Thanks for sharing
Useful as always, thanks Ankit. The difference between the two functions is tricky, thanks for bringing that up.
Glad it was helpful!
Actually it is not about how the functions work as they work both in exactly same way, the confusion is caused by how the ORDER BY clause within window function changes the data frames which are being taken to the functions to calculate the result for each row.
Thank you so much Ankit Sir your explanation is fantastic.......😊
Most welcome 😊
Thanks for this video. It was super useful!!!
Glad it was helpful!
Today i was studying for an interview.. and i was not understanding this concept.. thank you for this topic 🙏
All the best
Fantastic Information. Thank you Ankit
Thanks and welcome
Hey Ankit!!
You are giving me hope in technical aspects video by video
All the best
Thankyou So much Sir for this Amazing Guidance
Most welcome
Great Tutorial. Thanks Sir
You are most welcome
Hello Ankit,
Thank you for making such insightful videos.
I want to ask a question here.
I have come across in a lot of interviews that they ask to solve a question without using a window function. Is there any trick to solving such questions? Can you provide us with an example.
At 7:39 ...why you again added order by emp_age at end of query even though you used order by in OVER clause.
Even if you didn't add order by at the end the output looks same right
That's just to sort the result in output. Even if you don't do it the result will be same
@@ankitbansal6 okay..thanks sir
wow....Literally Awesome :)
Thank you! Cheers!
Thank you new thing for me
Thanks Brother for the Continues great Work.
Just asking if you can start any GCP Engineering concepts also like Dataflow, composer
I liked the explanation part
Thank u😊
You're welcome 😊
Hello Ankit,
We can also use Join by 'using' keyword.
For suppose, generally we write join like : a join b on a.id=b.id
So by using keyword we can write like: a join b using id
So many of them don't know that 'Using' keyword.
Can you please make a video on it.
And yeah i had used that first_value and last_value function
Good one, nicely explained 👍
Glad you liked it
Very well Explained :)
Thank you 🙂
Nice
Can you provide documents related to Oracle and plsql... I think your documents easy to understand..
Yet another great video Ankit. Just a doubt I had in the frame clause : last_value(emp_name) over(order by emp_age rows between current row and unbounded following)
last_value(emp_name) over(order by emp_age rows between unbounded preceding and unbounded following)
Both above frame clauses give same results, right?
Yes
Great !!
Make a video on EXIST
In the LAST_VALUE function..you used ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING.....does this work on WINDOW FUNCTION we use or both on ORDER BY and WINDOW FUNCTION we have used?
Yes all aggregation functions it works
@@ankitbansal6 Thanks 🙏🏻
if we can order by asc or desc why we need last_value function? we can bring last_value just adding desc at the end of the order by.
Exactly. We don't need it. 😊
Applied in example
Anable to see any thing video
firstly ensure the code you give us is accurate, you have ELEVEN ppl in your code yet TEN in the code in the comments