/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

0 vote232 views1 answer
Sql server query database space available
SQL
0 vote232 views1 answer
Executescalar in sql server
SQL
17 votes235 views6 answers
Sql select distinct
SQL
1 vote231 views1 answer
Postgres delete from where date is greater than specific date
SQL
1 vote249 views1 answer
How to fetch alternate records from two tables
SQL
0 vote240 views1 answer
Oracle last connexion
SQL
0 vote241 views1 answer
Create a sql server database programmatically
SQL
2 votes278 views3 answers
How to replace null values in sql
SQL
0 vote233 views1 answer
Unique element in sql
SQL
0 vote247 views1 answer
How to add mysql to path on termin after installation
SQL