sql select most frequent value in column

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

Search
showing results for - "sql select most frequent value in column"
Ashley
01 Jun 2018
1SELECT col, COUNT(col) AS value_occurrence
2FROM m_table GROUP BY col ORDER BY value_occurrence DESC LIMIT 1;
3
4-- Oracle <= 11g
5SELECT * FROM (SELECT col, COUNT(col) AS value_occurrence
6FROM m_table GROUP BY col ORDER BY value_occurrence DESC)
7WHERE rownum = 1;
similar questions
how to find the most occuring in sqltsql find the value and count of the item that occurs the most in a columnwhat is top n result in sqlsql alternative to max statementfind lowest number in sqlsql select max value from multiple rowsselect top 10 rows in sqlfind most frequent value in sql columnhow to get alternate records from a table 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 serverhow to select only the first rows for each unique value of a sql tablecolumn 3fsql row having maxsql select max value for each groupsql select first and last record of each groupsql select most frequent value in groupsql get most recent recordsql select rows with different values in one columnhow to find lowest in sqlsql select whole row max columnsql select row with max datesql select second maxselect all same column value in sql
queries leading to this page
select most frequent value sqlsql count most frequent valuesfind most frequent value in sql columnmost frequent data in a column sqlsql most frequent value colomhow to display the most frequent value in a column sqlfind most frequent value in sql columnnsql query find most frequent valueselect frequent value sqlselect most frequent field sqlget the most frequent value sqlget most frequent value in column sql serversql select most frequent value in columnselect 3 most frequent element in table sqlhow to get the most frequent value in a column sqlsql select most frequent value in column