mysqli query order by before group by

Solutions on MaxInterview for mysqli query order by before group by by the best coders in the world

Search
showing results for - "mysqli query order by before group by"
Colin
04 Apr 2017
1//it is very difficult to find a query that uses Order By before Group By
2//so, below is the query when you want to first order the results in Asc (min) or Desc (max) order, and then Group by
3$raw_query = 'SELECT p1.* FROM table1 p1
4         INNER JOIN ( SELECT max(firstValue) MaxAnyId, secondValue
5                            FROM table1
6                            WHERE user_id=162
7                               AND status_id=70
8                            GROUP BY secondValue
9                        ) p2
10                          ON p1.secondValue = p2.secondValue
11                          AND p1.firstValue = p2.MaxLogId
12                        WHERE p1.user_id=162
13                          AND p1.status_id=70
14                        order by p1.firstValue desc';
15                        
16//for Laravel ->                        
17$q = \DB::select($raw_query);
similar questions
elasticsearch for group by like in sqlgroup by sql not ordering issuesgroupby sort sql hivemysql group by monthmysql group by derived columnmysql group by limitselect query group by namecodeigniter mysql issue with select 26 group by
queries leading to this page
group by after order bygroup by and order by mysqlgroup by order by mysqlorder by before group by in mysqlmysql group by order byorder by and group by mysqlorder by group by mysqlmysqli orderby before group bymyslq keep order in group bysql order before grouporder by before group byorder by dont sort group by mysqlgroup by then order byorder by grouping mysqlorder by group php mysqlimysql ignore orderby when groupby is presenthow to group by id and order by asc in mysqlimysqli query order by desc an group bymysqli query order by before group byorder by then group bymysql group by order lastmysqli query order by before group by