This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.
How to group query by x unit
Hi,
I'm using this little query :
It show's me how page is printed by user. My SQL is quite old and I can't remember how to "summarize" those data.
I want to know how many users have for exemple :
1 to 500 copies
501 to 1000 copies
etc...
Thx for help.
I'm using this little query :
SELECT Sum(PageCount) as NbPage, UserLogon FROM AuditTrail
where CostCentreName = 'Etudiant'
and Timestamp >= convert(datetime, '2011/04/13')
group by UserLogon order by NbPage desc
It show's me how page is printed by user. My SQL is quite old and I can't remember how to "summarize" those data.
I want to know how many users have for exemple :
1 to 500 copies
501 to 1000 copies
etc...
Thx for help.
Asked:
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
select case when NbPage between 1 and 500 then '1-500'
when NbPage between 501 and 1000 then '501-1000'
end + ' Copies' , count(*)
from (
SELECT Sum(PageCount) as NbPage, UserLogon FROM AuditTrail
where CostCentreName = 'Etudiant'
and Timestamp >= convert(datetime, '2011/04/13')
group by UserLogon order by NbPage desc
) t
group by case when NbPage between 1 and 500 then '1-500'
when NbPage between 501 and 1000 then '501-1000'
end