How to use row_number to calculate the continuous operation days of the same user

This article mainly explains "how to use row_number to find the continuous operation days of the same user". The explanation in the article is simple and clear, and it is easy to learn and understand. Please follow the editor's train of thought to study and learn "how to use row_number to find the continuous operation days of the same user".

Select name,id,min (day), max (day) from (select t.times, row_number () over (order by day)-row_number () over (partition by name,id order by day) as grp from tbl t) tgroup by name,id,grp thank you for your reading. This is the content of "how to use row_number to calculate the continuous operation days of the same user". After the study of this article I believe that we have a deeper understanding of how to use row_number to find the continuous operation days of the same user, and the specific use needs to be verified in practice. Here is, the editor will push for you more related knowledge points of the article, welcome to follow!