Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
Q
Q
Qairat2017-11-27 14:10:55
SQL
Qairat, 2017-11-27 14:10:55

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

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

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
L
Lazy @BojackHorseman, 2017-11-27
SQL

row_number()

Similar questions
D
ddem72017-09-26 22:29:19
How to exclude re-counting the number of views per IP for popular WordPress posts? 3Reply
D
Donald_Duck2017-12-29 10:56:47
Is the line 'App\Model' => 'App\Policies\ModelPolicy' needed in the list of policies or can it be removed? 3Reply
A
Andrey Strelkov2020-01-20 08:43:14
How to add an enumerator to groups of similar records in a SQL query? 1Reply
M
Mikhail Smykov2015-09-14 18:34:12
How do I manage the cassandra database? 2Reply
A
Andrey Strelkov2020-01-22 14:39:58
How to list values ​​using LISTAGG in a query with many JOINs from different tables? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question