The forums ran from 2008-2020 and are now closed and viewable here as an archive.
Home › Forums › CSS › mysql – select users with max(field) and min(field)
I have table (results) with theses fields result_id username true false
i want select users which have max(true) and min(false)
for example , if 2 users have the following x-> true(20) , false(10) y – > true(15) , false(2)
i want choose the y first as it’s percentage is high
i mean making percentage between true , false