/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 vote294 views1 answer
How to get table current identity value in sql server
SQL
0 vote308 views1 answer
Compare two tables to find unmatched records
SQL
11 votes293 views4 answers
Round in sql
SQL
0 vote294 views1 answer
Add SuperUser MySQL
SQL
0 vote295 views3 answers
Find below average salary in sql
SQL
0 vote314 views2 answers
Advantages of stored procedures sql
SQL
2 votes334 views1 answer
Where clause for child record apex
SQL
0 vote296 views1 answer
Get only structure database mysql
SQL
1 vote288 views6 answers
In sql
SQL
0 vote301 views1 answer
Postgresql not in alternative
SQL