+Алексей Руденко Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you th-cam.com/users/kudvenkatplaylists?view=1&sort=dd If you need all the videos and slides for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. th-cam.com/video/y780MwhY70s/w-d-xo.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. th-cam.com/users/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
OVER Partintion by RULES. And Venkat Rules ! Tahnk U for educating community. I watched all your videos and i'm impressed. Thank U . Yoy are the best teacher in the world and youtube !
This actually the way I would like to teach. You show how complicated a solution is and you show and explain a simpler solution, thanks kudos excilent!
I really understood. Before, I always stucked with this problem: whenever I want to retrieve columns like names, salary etc. as grouping with another column that error comes up. However, if we use subquery we'll able to fix that. But subquery may be fuzzy so that we use over. It's brillant, I'm really happy to understand this.
Thank you for taking the time to post this video. Your explanation of this function was the best I have seen when trying to figure out the use of the "Partition.. Over()" function. Very helpful.
Hello Mudasir - Thank you very much Greatly honoured. Means a lot. I have included all the SQL tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy. www.pragimtech.com/courses/sql-server-tutorial-for-beginners/ If you have time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
You are a great teacher. Very good examples, very helpful tutorials, and your English is really good so it is easy to follow along to your instruction!
Very Well explained Alternate Solution using CTE select Gender,count(Gender) GenderTotal,avg(Salary) AvgSalary, Min(Salary) as MIN , Max(Salary) as MaxSalary from (select Salary,Gender,Count(Gender) over (partition by Gender) as RN from Employees ) result group by Gender
Hello Venkat, In this example, in over clause, we are not specifying rows between clause. How its summing up all the rows values. Ideally it should take unbounded preceeding and current row as default. Can you please explain
The default window frame without the ORDER BY is the whole partition. But when you use the ORDER BY, the default window frame is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.
Thank you Yen. Means a lot. Your review and feedback really helps. Hope you have a few minutes to write a review. Thank you for your time. g.page/r/CdKOVS3cTnYnEAg/review
Hi Venkat. Thank you for your tutorials. Can I ask. I thought the OVER clause had to be used with the ORDER BY clause. I'm just wondering here why the default 'RANGE BY UNBOUNDED PRECEEDING AND UNBOUNDED CURRENT ROW' does not apply here. Is it because you have used the PARTITION BY clause without the ORDER BY clause? Thanks funkychimp
Thanks for the amazing n interesting videos. Helps a lot in our daily tasks. I am not sure the discussion forum is active. Could you please explain how to extract only the Max. Salaries for Male and Female along with other column fields for that record. Thanks !
+malhar jajoo I'm not criticizing him, in any way. Quite opposite of that. I just noticed the Indians are in everywhere seeding great materials. As SQLAuthority and JavaBrains channel have done as well.
How come the avg in the over clause is not generating running average, I am confused what generates a running aggregate or just one value per partition by
The number of views for videos such as these makes me worry for our future. This video should have 2M views by now.... oh wait, let's go watch baby shark one more time
Amazing video, thanks a lot!
+Алексей Руденко Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
th-cam.com/users/kudvenkatplaylists?view=1&sort=dd
If you need all the videos and slides for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
th-cam.com/video/y780MwhY70s/w-d-xo.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
th-cam.com/users/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
Among the best Teachers I have found on TH-cam. He has that skills of shredding complex things and explaining it in a simple manner. Kudos !
there real talent comes out
What I love about your videos is that you stick to one topic. You don't add material that is not directly related. It makes my life easier. Thank you.
OVER Partintion by RULES. And Venkat Rules ! Tahnk U for educating community. I watched all your videos and i'm impressed. Thank U . Yoy are the best teacher in the world and youtube !
The best Teachers and also the best Programmer who have too much clear concept I have found on TH-cam
This was an excellent example for the OVER and PARTITION BY clauses. I learned a lot by watching this, again, excellent!!!
This actually the way I would like to teach. You show how complicated a solution is and you show and explain a simpler solution, thanks kudos excilent!
This was an amazing and easy to understand explanation of over and partition by in relation to aggregate functions!!! Thank you!!!
I really understood. Before, I always stucked with this problem: whenever I want to retrieve columns like names, salary etc. as grouping with another column that error comes up. However, if we use subquery we'll able to fix that. But subquery may be fuzzy so that we use over. It's brillant, I'm really happy to understand this.
Thank you for taking the time to post this video. Your explanation of this function was the best I have seen when trying to figure out the use of the "Partition.. Over()" function. Very helpful.
You have really simplified my work in SQL queries, thank you sir
You are ray of light for lot of people Venkat. … God bless you !!!!!
Hello Mudasir - Thank you very much Greatly honoured. Means a lot. I have included all the SQL tutorial videos, slides and text articles in sequence on the following page. Hope you will find it handy.
www.pragimtech.com/courses/sql-server-tutorial-for-beginners/
If you have time, can you please leave your rating and valuable feedback on the reviews tab. It really helps us. Thank you. Good luck and all the very best with everything you are doing.
You are a great teacher. Very good examples, very helpful tutorials, and your English is really good so it is easy to follow along to your instruction!
This is the only correct way of explaining OVER: by relating it with GROUP BY.
Kudos very well explained sir good example taken. Please bring a SQL interview series. Nowadays it well appreciated by audience.
This is amazing!!! You are very good at explaining complex concepts and make them easy to understand
Thank you for this video! Clean, clear, and I really appreciate the comparisons to other methods.
Dear sir it s very nice and i am watching ur videos up to 68 part i learning every day new concepts
Venkat, You should have a lot more subscribers.. Your vids are tops!!
Very Well explained
Alternate Solution using CTE
select Gender,count(Gender) GenderTotal,avg(Salary) AvgSalary, Min(Salary) as MIN , Max(Salary) as MaxSalary from
(select Salary,Gender,Count(Gender) over (partition by Gender) as RN from Employees )
result
group by Gender
This is an excellent channel. I am so glad I found it!
Thanks for the video and making it easy to understand!
Thanks @kudvenkat for such clean explanation! I was confused about use of over for long time and I struck the gold here
thank you for sharing this knowledge...it really helped me today. ✌
Thank you! It is a very helpfull video tutorial. Now the Over clause is realy clear for me.
Very good explanation, superrrrr !!! thanks 💕
Excellent tutorial video with practical samples, thank you.
Very well explained! New subscriber inserted to the table.
Genus on the way you explained this !! Thank you !!
You're a great teacher. Thanks
Excellent teaching as always!
Very nice! Another useful tool! Thanks.
Very well explained, thank you!
easily understandable, great job!
Thank you so much. You are an awesome teacher
Such clear explanation, thank you!
To the point this is good stuff👌👍
Excellent video,clear logic ! thanks a million man
Thanks a lot for this tutorial, I finally could understand it :D
Thank you for these tutorials, they are really great.
this mean a lot for me thanks for teaching the world
Great explanation and examples.
Superb explanation thanks alot
Awesome video. So nicely explained!!!!
Awesome Explanation!
what a powerful tool! -over.
Nicely explained!
Great Video, pretty clear and didactic.
This is very clear, thank you so much!
Well explained 👍
Thank you very very much!!!🙏🙏
Thank you, the video is so useful!!!
Easy and comprehensive
Thanks
Hello Venkat,
In this example, in over clause, we are not specifying rows between clause. How its summing up all the rows values. Ideally it should take unbounded preceeding and current row as default.
Can you please explain
The default window frame without the ORDER BY is the whole partition. But when you use the ORDER BY, the default window frame is RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW.
superbly done. Kudos.. :)
Well explained video. Thank you.
Amazing tutorial. Thank you
Thank you Yen. Means a lot. Your review and feedback really helps. Hope you have a few minutes to write a review. Thank you for your time.
g.page/r/CdKOVS3cTnYnEAg/review
AWESOME ....!
THANK U SIR...!
very nice...thank u so much...
Hi Venkat. Thank you for your tutorials. Can I ask. I thought the OVER clause had to be used with the ORDER BY clause. I'm just wondering here why the default 'RANGE BY UNBOUNDED PRECEEDING AND UNBOUNDED CURRENT ROW' does not apply here. Is it because you have used the PARTITION BY clause without the ORDER BY clause? Thanks funkychimp
same question....does anyone has it's answer
great video, thanks!
Super neat concept! Is there a large performance difference between sub query vs over method?
Thank you so much it was great help
As usual perfect
thnx u for ur services
Thanks for the amazing n interesting videos. Helps a lot in our daily tasks.
I am not sure the discussion forum is active. Could you please explain how to extract only the Max. Salaries for Male and Female along with other column fields for that record. Thanks !
simply awesome
At 6:22 in over clause used table, how do you get Name column Tom Ron Ben Todd Mark John in this sorting. Can someone xplain please, Thanks in advance
why this is no ROWS clause in OVER() but the AVG() calculates for all rows in the partition?
Well explained! Thanks
Thanks you! very useful!
this is so amazing stuff
Thank you Venkat.. :)
Thank you 💌
Indian, Always amazing! What would about us, without them?!
+Yuri Fontoura What would about us, indeed.
+Yuri Fontoura _ at least he is explaining difficult concepts man pardon his english
+malhar jajoo I'm not criticizing him, in any way. Quite opposite of that. I just noticed the Indians are in everywhere seeding great materials. As SQLAuthority and JavaBrains channel have done as well.
Thank you sir!!
Thank you very much!!!
We are partitioning 4 times in this example. Which query would be an optimal one in terms of performance?
Does over function don't take default range as unbounded preceding and current row ??
How come the avg in the over clause is not generating running average, I am confused what generates a running aggregate or just one value per partition by
thank you merlin :-D
How come the query with aggregate functions created results as if rows between unbounded preceding and unbounded following is specified?
thankyou very much
Forgive my ignorance but wouldn't the query in the JOIN clause be a Derived table and not a sub query?
Hi, Could you please also explain how to us Red Gate s/w for transferring data from one server to another
Thanks! This helped!
Great!
hi sir .good afternoon
thank you for providing video tutorial of .net
sir would you teach, about data View and its uses and properties
And DataTable
excellent
why didn't you use "unbounded preceding and unbounded following" here as u used in other video?.....could u please explain it
Thanks mate!
Yu da best!!!
THANK YOU!
On page 6 of the slide, how come Gender is in the subquery when it doesn't have aggregations?
Thank You
My respect
thanks
👍
The number of views for videos such as these makes me worry for our future. This video should have 2M views by now.... oh wait, let's go watch baby shark one more time
WHAT DO OVER(*) ?