[quoted text, click to view]

Hi Ronny,

SELECT SYS.Client_Version0, SYS.Client_Type0, count(*) as 'Count',
count(*) * 100.0 / (select count(*) from v_R_System) as 'Percent'
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

(untested)

Best, Hugo
--

Hello Ronny,

Pls clarify the %age against the
- total records count in table or
- Total records counts in SYS.Client_Version0
As you are using 2 columns in your select query

For first case solution is already provided.
But for secound case , find the query

SELECT SYS.Client_Version0,
SYS.Client_Type0, ((count(*) * 100)/( SELECT count(*) FROM v_R_System as
Sub_SYS WHERE SYS.Client0=1 and Sub_SYS.Client_Version0 =
SYS.Client_Version0)) as 'Percentage'
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

(Untested)



[quoted text, click to view]