mysql select top n rows per group

Solutions on MaxInterview for mysql select top n rows per group by the best coders in the world

Search
showing results for - "mysql select top n rows per group"
Lukas
22 Aug 2019
1CREATE TABLE yourtable (
2  year int,
3  id varchar(20),
4  rate decimal(10,2)
5);
6
7SELECT yourtable.*
8FROM   yourtable 
9INNER JOIN (
10  SELECT   id, GROUP_CONCAT(year ORDER BY rate DESC) grouped_year
11  FROM     yourtable
12  GROUP BY id) group_max
13ON yourtable.id = group_max.id AND FIND_IN_SET(year, grouped_year) <=5
14ORDER BY yourtable.id, yourtable.year DESC;
source
similar questions
mysql select top 2how to select all attributes from a row if there is a certain string in it mysqlsql server select top 2 of each groupmysql select multiple rows into one columnmysql select inside summysql select bottom 10 rowsmysql query single rowsql select first record of each groupget top 1 row of each grouphow to find the top 2 unique records using mysqlhow to get first 10 records of a table in mysqlmysql group rows with same valuetop 10 rows in mysqlreturn the number of records in a single table mysqlmysql select row with max value group bysql select most frequent value in groupmysql count grouped rowsmysql find the row ites of the hoghest value at on columnmysql record group by created date counthow to get button for every record from mysqlget only one row in mysqlget number of rows in every table mysql
queries leading to this page
how to select top 5 rows with group by in mysqlmysql limt by groupmysql group by max limit 1mysql max group bymysql group by order by limit 1mysql limit for each groupgroup by and limit mysql not workingmysql group by limit offsetmysql select top 1 from each groupmysql group limitmysql get one row per grouplimit according to group by mysqlmysql group by limitmysql get top 10 records from each groupgroup by and limit in mysqlmysql limit in each groupgroup by with limit mysqlmysql select group by limitgroup by limit mysqlmysql group by order by limitmysql select only one row per groupmysql group by maxgroup by with limit in mysqlmysql limit group byget data with group by and limit in mysqlgroup and limit with year mysqlmysql select top n rows per group