SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …

Oracle SQL: Summarize a calculated column (like a count(*) column) with ROLLUP

You have a simple sql statement like this:

select machine, count(*) as users
from v$session
group by machine

This query returns the session count on each machine:

MACHINE USERS
machine1 16
machine2 17
machine3 15
machine4 14

Bookmark It