04-16-2010, 01:49 PM
|
|
Planar Protector
Join Date: Oct 2009
Posts: 4,028
|
|
Quote:
select Character_.class, count(Character_.id) as 'Amount',
(count(Character_.id) / (select count(Character_.id) from Character_ where Character_.level between @LowerLevel and @UpperLevel)) as '% of Total'
from Character_
where Character_.level between @LowerLevel and @UpperLevel
group by Character_.class
order by Character_.class
|
Oooh, I like!
__________________
Quote:
Originally Posted by nilbog
Server chat is for civil conversation. Personal attacks/generally being confrontational will not be tolerated.
|
|
|
|
|