Answers for "get most common value mysql"

SQL
1

mysql find most common value

SELECT column, COUNT(*) AS magnitude 
FROM table 
GROUP BY column 
ORDER BY magnitude DESC
LIMIT 1
Posted by: Guest on April-03-2021

Code answers related to "get most common value mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language