Hello, Frederick. First of all, thanks for your work, it’s really helpful for beginners and intermediates. Instead of using LIMIT OFFSET, we can come up with ROW_NUMBER and have WHERE clause row_num >= 7 (7th day and the following)
Hallo frederik, ich viel mag deine videos, kannst du machen other videos about other sql plans maybe hackerrank's or leetcode premiums ? (Thats all i remember from german class haha)
![LeetCode 1341: Movie Rating [SQL]](/img/1.gif)
Hello, Frederick. First of all, thanks for your work, it’s really helpful for beginners and intermediates.
Instead of using LIMIT OFFSET, we can come up with ROW_NUMBER and have WHERE clause row_num >= 7 (7th day and the following)
Yes, that works well!
Hi Fredrick, keep up the good work! This is really helpful, thought I was getting rusty and came back to your channel for more hands on.
Hey, please make more content on window functions, as it is being asked a lot in interviews lately. Thanks for this simple explanation though 😊
Sure thing! Thanks for watching and leaving a comment.
Hallo frederik, ich viel mag deine videos, kannst du machen other videos about other sql plans maybe hackerrank's or leetcode premiums ? (Thats all i remember from german class haha)
Ja, vielleicht sollte ich alle Hackerrank Fragen machen 🤔 (I was able to understand from his broken German)