Answers for "mysql find most common value"

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 "mysql find most common value"

Code answers related to "SQL"

Browse Popular Code Answers by Language