/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 vote232 views1 answer
Mysql workbench in ubuntu 14.04
SQL
0 vote209 views1 answer
Minus equivalent in my sql
SQL
0 vote214 views1 answer
See Foreign Key
SQL
0 vote214 views1 answer
Postgresql where clause not working
SQL
3 votes222 views2 answers
Sql asc
SQL
0 vote209 views1 answer
Change schema of all tables postgres
SQL
0 vote212 views1 answer
Do postgresql
SQL
0 vote235 views1 answer
Mysqli::query(): (HY000/1034): Index for table 'db' is corrupt; try to repair it
SQL
0 vote260 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
6 votes214 views2 answers
Mysql get yesterday
SQL