Guest tuxedup Posted February 10, 2009 Report Share Posted February 10, 2009 Hello, First off, I would like to appologise if I have posted this to the wrong area. I am a begginer so I fiogured that it would still be appropriate for the section. Anyway, I would like to know, what would be the SQL query to find the most common record within a table. The table has two fields (Hit_Id and Page_Id). Hit_Id automatically increments, whilst Page_Id is manually filled with entires such as GPL2, GPL3, BSD, MPL etc. How would which item within the Page_Id field is the most common? Thanks very much Tuxedup Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.