Revisions to Mysql - Grouping and getting the Max(col1) row variables

Formatting

Source Link

edited Sep 19, 2017 at 4:20

90.3k
30
424
663

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

IF This query is not correct then you can try this query

SELECT id,col1,col2,col3, riskLvel FROM table1 where col1 IN ( SELECT MAX(col1) FROM table1 GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
    FROM table1
    where col1 IN ( SELECT MAX(col1)
                         FROM table1
                         GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

IF This query is not correct then you can try this query

SELECT id,col1,col2,col3, riskLvel FROM table1 where col1 IN ( SELECT MAX(col1) FROM table1 GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

IF This query is not correct then you can try this query

SELECT id,col1,col2,col3, riskLvel
    FROM table1
    where col1 IN ( SELECT MAX(col1)
                         FROM table1
                         GROUP BY col1 )

added 237 characters in body

Source Link

edited Feb 18, 2017 at 19:17

Nishant Uppal

29
4

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

IF This query is not correct then you can try this query

SELECT id,col1,col2,col3, riskLvel FROM table1 where col1 IN ( SELECT MAX(col1) FROM table1 GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

IF This query is not correct then you can try this query

SELECT id,col1,col2,col3, riskLvel FROM table1 where col1 IN ( SELECT MAX(col1) FROM table1 GROUP BY col1 )

added 20 characters in body

Source Link

edited Feb 17, 2017 at 18:26

ypercubeᵀᴹ

98.6k
13
215
305

SELECT id,col1,col2,col3, riskLvel FROM table1 where risklevel IN ( SELECT MAX(riskLevel) FROM table1 GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel FROM table1 where risklevel IN ( SELECT MAX(riskLevel) FROM table1 GROUP BY col1 )

SELECT id,col1,col2,col3, riskLvel
FROM table1
where risklevel IN ( SELECT MAX(riskLevel)
                     FROM table1
                     GROUP BY col1 )

Source Link

created Feb 17, 2017 at 17:54

Nishant Uppal

29
4

Loading

Stack Exchange Network

Return to Answer