SQL : Using GROUP BY and MAX on multiple columns SQL : Using GROUP BY and MAX on multiple columns sql sql

SQL : Using GROUP BY and MAX on multiple columns


sql mysql

You can get the best attrib1 values, and then join in the attrib2 values and get the best of those for each attrib1 value:

select t2.catID, t2.attrib1, max(t2.attrib2)from(  select catID, max(attrib1) as attrib1  from test_table  group by catID) t1inner join test_table t2 on t2.catID = t1.catID and t2.attrib1 = t1.attrib1group by t2.catID, t2.attrib1

sql mysql

Use:

SELECT x.catid,       x.max_attrib1 AS attrib1,       (SELECT MAX(attrib2)          FROM YOUR_TABLE y         WHERE y.catid = x.catid           AND y.attrib1 = x.max_attrib1) AS attrib2  FROM (SELECT t.catid,               MAX(t.attrib1) AS max_attrib1          FROM YOUR_TABLE t      GROUP BY t.catid) x

sql mysql 

SELECT tt.catId, tt.attrib1, MAX(tt.attrib2)FROM   test_table ttGROUP BY tt.catID, tt.attrib1WHERE  tt.attrib1 = (SELECT MAX(t2.attrib1) FROM test_table t2 WHERE t2.catID = tt.catID)

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last