How to select 5 latest entries by last 3 dates for each group?

Q

Qairat2017-11-27 14:10:55

SQL

Qairat, 2017-11-27 14:10:55

It is not possible to select the last 5 data, by the last 3 dates for each group via mssql.
Here is my code .
Thanks in advance!

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

L

Lazy @BojackHorseman, 2017-11-27
SQL

row_number()

Similar questions

A

Anholle2019-09-09 11:37:42

P

penexe2013-06-10 18:37:53

P

Pavel Bogdanov2016-02-02 09:04:29

I

Ivan Panteleev2013-06-28 13:21:16

L

Lev Rozanov2016-02-04 21:08:13

Didn't find what you were looking for?