<div>
try this<br />

<pre><code id="code-32824">select top 1 * from(
select MembeID ,count(*) as c from insurance
group by MembeID) as t
order by c desc
</code></pre>
</div>


try this


select top 1 * from(
select MembeID ,count(*) as c from insurance
group by MembeID) as t
order by c desc


<div>
@HuyBD: Just for my learning, does TOP 1 work in MySQL as well ?
</div>


@HuyBD: Just for my learning, does TOP 1 work in MySQL as well ?

<div>
<div class="content wysiwyg-content">
How can I select maximim top frequency duplicate MembeID<br />

<pre><code id="code-32812">CREATE TABLE `insurance` (
  `insurprimarykey` int(11) NOT NULL AUTO_INCREMENT,
  `Insurkey` int(11) DEFAULT '0',
  `MembeID` int(11) DEFAULT NULL,
  `MemberName` varchar(250) DEFAULT NULL,
  `Amount` decimal(11,0) DEFAULT NULL,  
  PRIMARY KEY  (`insurprimarykey`),
  KEY `Membe ID` (`MembeID`)
) ENGINE=InnoDB AUTO_INCREMENT=401 DEFAULT CHARSET=tis620;
</code></pre>
</div>
</div>


How can I select maximim top frequency duplicate MembeID

select the frequency member ID in MYSQL

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.