Question about SELECT statement
Hey people,
I am loggin my Apache acces log to a mysql database. There is one field containing the virtualhosts name. Each page request, is loged as a new row in the table.
I'd like to know how I can select the virutal host which has the highest count of page requests. So I want to select the virtual host, which occurs the most in my table.
How would I do that in SQL ?
Regards,
Samy
Subject
Views
Written By
Posted
Question about SELECT statement
2961
September 30, 2007 09:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.