On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <msivasakthi@gmail.com> 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/...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!