RE: Query help !

try:

SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count',
(count(*)* cast(100 as decimal) / cnt) 'pct'
FROM v_R_System as SYS ,
(select count(*) 'cnt' from v_R_System) b
WHERE SYS.Client0=1
group by SYS.Client_Version0, SYS.Client_Type0,cnt
order by SYS.Client_Version0, SYS.Client_Type0

--Vishal

"Ronny de Jong" wrote:

> Dear all,
>
> I'd like to display the result of this query in percentage:
>
> SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count'
> FROM v_R_System as SYS
> WHERE SYS.Client0=1
> group by SYS.Client_Version0, SYS.Client_Type0
> order by SYS.Client_Version0, SYS.Client_Type0
>
> Any idea's how,
>
> I appreciate your help....
> Ronny
.