1
votes

Is it possible to rank the following table:

+-------------------++-------------------+
| date              | user               |
+-------------------++-------------------+
| 2018-12-30        |   User 1           |
| 2018-12-31        |   User 1           |
| 2019-01-01        |   User 2           |
| 2019-01-02        |   User 2           |
| 2019-01-03        |   User 1           |
| 2019-01-06        |   User 1           |
| 2019-01-07        |   User 2           |
| 2019-01-08        |   User 2           |
+-------------------++-------------------+

in this way?

+-------------------++-------------------+++------+
| date              | user               | Rank   |
+-------------------++-------------------+++------+
| 2018-12-30        |   User 1           |  1     |
| 2018-12-31        |   User 1           |  1     |
| 2019-01-01        |   User 2           |  2     |
| 2019-01-02        |   User 2           |  2     |
| 2019-01-03        |   User 1           |  3     |
| 2019-01-06        |   User 1           |  3     |
| 2019-01-07        |   User 2           |  4     |
| 2019-01-08        |   User 2           |  4     |
+-------------------++-------------------+++------+
What does select version() show? - ysth
Is date unique? If not, do you care what order ties are considered to be in? - ysth