/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 vote234 views2 answers
Demmarrer un service mysql teminal cmd
SQL
0 vote213 views1 answer
Oracle sql number to varchar2
SQL
0 vote230 views1 answer
What is server_default = func.now() in sqlalchemy
SQL
0 vote197 views1 answer
Mysql workbench format date
SQL
0 vote223 views1 answer
How to see the query of a view in mysql
SQL
0 vote247 views1 answer
Oracle sql date winter time
SQL
3 votes148 views2 answers
Mysql sum with condition
SQL
3 votes224 views1 answer
What is having
SQL
-1 vote208 views3 answers
Psql get last rows
SQL
20 votes188 views1 answer
Get all table name in sql through php
SQL