Row number rules ! And Venkat rules! You are the best teacher on youtube and in the whole world. I saw all your videos from SQL Server tutorial. Thank U for educating community! God bless you.
Tried so many videos on RU-vid after a few minutes I come out of it as I don't understand what they are talking about. You are the best:) Explained all concepts very clearly I found not just a good teacher but also a great soul :) Your voice is very soothing and pleasant on the ears wanting to listen more and more. God Bless you and Thanks once again
You are very welcome and 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 ru-vid.complaylists?view=1&sort=dd If you need DVDs or to download all the videos 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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-y780MwhY70s.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ru-vid.com 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
@@Csharp-video-tutorialsBlogspot - Do you provide training on SQL SERVER DBA /Azure DBA..or any videos on Clustering and login users /different types of roles or access in sql. my number 9030014648
When we are populating the result set in subquery which is captured within CTE and then we are deleting only from that CTE itself, then how come the original table employee is getting affected? I have again watched the part where you have explained CTE but didn't understand this. Could you kindly help. Ohh and by the way the whole series is very helpful, KUDOS!! to you Venkat for helping so many people with your great knowledge and impeccable teaching talent!!
Hello Venkat, i dont understand why we delete the data from CTE it delete the data in the real table. I thought the data from CTE is the difference from the table. ?
Whether can v hav row_number as auto increment without repeating. First time if I m executing the select stt i should get 1,2,3 n if I m executing 2nd time i should get 4,5.
can you explain in what order is the male part of the row number assigned after executing the commend... "Tom, Ron, Ben, Todd, Mark, John' does not come as the same order in the original table and it is not in any asc or desc order neither.
its maximum row size exceeds the allowed maximum of 8060 bytes. INSERT or UPDATE to this table will fail if the resulting row exceeds the size limit. how to over come this warning
Hi, thanks for the video, this seems like a very simple function, i have tried it and it seems like its working by its actually returning an empty column, this is my exact code: ROW_NUMBER() OVER (PARTITION BY orddet_nl.invnum ORDER BY orddet_nl.invnum ASC) AS LineReference, i dont get any error messages or anything, but it just brings an empty column, any ideas why? Thanks
Hi Venkat, I have data that has following rows.... 2934046 Kellogg’s Share Your Breakfast 74672 2407522 Kellogg?s Share Your Breakfast ACTIVE 2015-09-01 9999-12-31 2934046 Kellogg?s Share Your Breakfast 74672 2407522 Kellogg?s Share Your Breakfast ACTIVE 2015-09-01 9999-12-31 You can see that both rows are the same except for the question mark in the second row. I have to remove such rows from my table. I was trying to use row_number for this, but it doesn't work. Is there any way i can rank such rows based on the characters in my second column...
-- This query will give you 1 row with the max row number: SELECT TOP 1 *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ORDER BY RowNumber DESC; -- This query will give you ALL rows with the max row number: WITH RowNumberCTE AS ( SELECT *, ROW_NUMBER()OVER(PARTITION BY ID ORDER BY ID) AS RowNumber FROM Employees ) SELECT * FROM RowNumberCTE WHERE RowNumber = (SELECT TOP 1 * FROM (SELECT ROW_NUMBER() OVER (PARTITION BY ID ORDER BY ID) AS RowNumbers FROM Employees) DerivedTable ORDER BY RowNumbers DESC) -- I know it's not a nice piece of code but it does the job.