'How to get Row Number List Group

This is my current table result after select

select waktuabsen::date as Date, waktuabsen as AttendanceTime 
from tabsen

enter image description here

I want to add a column that counts the group list no. Let's just the column GroupListNo and the result that I want should be like this:

enter image description here



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source