Answers for "i wanted to select among the rows the highest value in mysql"

i wanted to select among the rows the highest value in mysql

select yt.id, yt.rev, yt.contents
    from YourTable yt
    where rev = 
        (select max(rev) from YourTable st where yt.id=st.id)

Posted by: Guest on December-03-2021

Code answers related to "i wanted to select among the rows the highest value in mysql"