<div>
SELECT thepage,ip,COUNT(ip) AS ipcount FROM statslog GROUP BY ip ORDER BY ip,thepage DESC LIMIT 20;
</div>


SELECT thepage,ip,COUNT(ip) AS ipcount FROM statslog GROUP BY ip ORDER BY ip,thepage DESC LIMIT 20;

<div>
<div class="content wysiwyg-content">
 &quot;INSERT INTO statslog (ip,accesstime,thepage,the<wbr />type,succe<wbr />ssCode,the<wbr />bytes) <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES ('$ip','$access_time','$li<wbr />nk[0]','$l<wbr />ink[1]','$<wbr />success_co<wbr />de','$byte<wbr />s')&quot;;<br />
<br />
I am doing log anaylsis. I inserted these fields into table.<br />
How can I get TOP 20 Hits URL from thepage field?<br />
How can I get TOP 20 IP addres from ip field?<br />
I am using MySQL..so I can't use select TOP 10...<br />
<br />
Thank you for your help.<br />

</div>
</div>


 "INSERT INTO statslog (ip,accesstime,thepage,thetype,successCode,thebytes) 
	VALUES ('$ip','$access_time','$link[0]','$link[1]','$success_code','$bytes')";

I am doing log anaylsis. I inserted these fields into table.
How can I get TOP 20 Hits URL from thepage field?
How can I get TOP 20 IP addres from ip field?
I am using MySQL..so I can't use select TOP 10...

Thank you for your help.


SQL, how can I retrieve top 20 hits?

Web development can range from developing the simplest static single page of plain text to the most complex web-based internet applications, electronic businesses, and social network services using a wide variety of languages and standards, including the familiar HTML, JavaScript and jQuery, ASP and ASP.NET, PHP, ColdFusion, CSS, PHP, Flex and Flash, but also the implementation of a broad list of standards including XML, WSDL, SSDL, VoiceXML and many more.