/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 vote225 views1 answer
Sql server loop over query
SQL
0 vote171 views1 answer
Mysql last 6 months
SQL
0 vote242 views1 answer
Mysql select row with min date
SQL
0 vote214 views1 answer
How to get data from 2 database
SQL
0 vote205 views4 answers
Mysql replace regex
SQL
15 votes189 views1 answer
Mysql int range
SQL
4 votes188 views4 answers
Date less than in sql
SQL
4 votes203 views1 answer
T-sql get duplicate rows
SQL
2 votes318 views1 answer
Mysql create user with remote access
SQL
0 vote218 views1 answer
Consecutive numbers sql
SQL