Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT
RowNum,
Y1.*
FROM
YourTable Y1
INNER JOIN (
SELECT
T1.UniqueOrKeyColumn,
RowNum=Count(*)
FROM
YourTable T1
INNER JOIN YourTable T2 ON T1.UniqueOrKeyColumn <= T2.UniqueOrKeyColumn
GROUP BY
T1.UniqueOrKeyColumn
) Y2 ON Y1.UniqueOrKeyColumn = Y2.UniqueOrKeyColumn