find most frequent value in sql column

Solutions on MaxInterview for find most frequent value in sql column by the best coders in the world

Search
showing results for - "find most frequent value in sql column"
Ilaria
02 Oct 2018
1SELECT       `column`,
2             COUNT(`column`) AS `value_occurrence` 
3    FROM     `my_table`
4    GROUP BY `column`
5    ORDER BY `value_occurrence` DESC
6    LIMIT    1;
similar questions
tsql find the value and count of the item that occurs the most in a columnsql display max valuefind lowest number in sqlsql set max value in columnfind max number in sqlsql find all different values in columnsql select lowest value rowhow to list all values of a column that start with a letter in sqlfind most frequent word in sql serversql use with to get value counts and percentagesmysql find most common valuesql select most frequent value in columnhow to select only the first rows for each unique value of a sql tablecolumn 3fhow to get max from each department in sqlfind number of entries sqlsql finding longest and shortest names in a fleldsecond last highest id in sqlsql select most frequent value in groupsql select maximum column with other columns returnedget a row where have list of array in sqlsql get most recent recordhow to find lowest in sqlsql select whole row max columnmaximum element in sql
queries leading to this page
most occurrence data in sqlget the most occurance in sqlsql find the most occurenceshow to get the most frequent value in a column sqlget most frequent value in column sql serverfind most frequent value in sql column