/SQL/Tsql find the value and count of the item that occurs the most in a column

Tsql find the value and count of the item that occurs the most in a column

select item, cnt
from (
  select
  	item
  	,cnt = count(*)
  	,seqnum = row_number() over (partition by id order by count(*) DESC)
  from 
  	src_table
  group by
  	item
) sub_qry

where seqnum = 1;

Source: stackoverflow.com

Similar codes

1 vote144 views1 answer
Store select query result in variable sql server
SQL
1 vote144 views1 answer
Get url of cpanel database hostname
SQL
0 vote151 views1 answer
How to find columns with null values in sql
SQL
5 votes161 views4 answers
Change auto increment mysql
SQL
0 vote156 views1 answer
Mysql database hyphen
SQL
2 votes147 views2 answers
Sql first character
SQL
0 vote173 views1 answer
How to fetch data from database in sql
SQL
14 votes149 views1 answer
Excel
SQL
5 votes163 views1 answer
Oracle add time to date
SQL
0 vote159 views1 answer
Primary key multiple
SQL