On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <[EMAIL PROTECTED]> wrote: > Hi all, > > Iam having the one table name called AccessDetails and data inside that > tables is following, > [snip=schema] > > In that , I need to calculate the number of total sites , number of > total Accessed Sites,number of total Denied Sites and number of total > Overriden Sites based on the particular Virus_Category,UserName,Date > > > How can form the query to achieve that?? > > I have used the following query but the total site is not correctly > displayed..
You may want to look into the ROLLUP modifier. Here's the manual entry: http://dev.mysql.com/doc/refman/5.0/en/group-by-modifiers.html -- </Daniel P. Brown> Ask me about: Dedicated servers starting @ $59.99/mo., VPS starting @ $19.99/mo., and shared hosting starting @ $2.50/mo. Unmanaged, managed, and fully-managed! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]