CODE EXAMPLE FOR SQL

FIND most frequent word in sql server

select top 3 senderName,  COUNT(senderName) as Top3 from remitTran(nolock) where 
pCountry='aaaa' and approvedDate between '2020-12-26' and '2020-12-28'  
group by senderName
order by count(sendername) desc