mysql group by limit

Solutions on MaxInterview for mysql group by limit by the best coders in the world

Search
showing results for - "mysql group by limit"
Adelia
25 Nov 2020
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
is there any limit of using joins in single mysql query 3fmysql limit order bymin max sql group bymysql sum with group bymysql count unique in group statementmysql group rows with same valuemysql multiple group bysql select max value for each groupgroupby error in mysqlmysql sum group bymysql select row with max value group bymysql group bymysql grouping functionsmysql group by derived columngroup by max datemysql count grouped rowsgroup concat limit mysqlmysql record group by created date countmysql group by daymysql group by datemysql group by monthgroup concat max length 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 group by limit