mysql - Get max value of a row in table -

hi trying row values having maximum of column name

table main

id|days|week 1 |1   |1 2 |2   |4 3 |5   |1 4 |2   |3 5 |1   |4 6 |4   |1 7 |1   |2 8 |6   |2

result needed

id|days|week 2 |2   |4 3 |5   |1 4 |2   |3 8 |6   |2

i using inner join group week .but expected result returning wrong values

without more info can , know not answer can expand on it.

select  min(id),max(days) ,week  main  group  week

you mention join. please post query.

Enable