Count How Many Entries for each UserID 1

[Michael42]

Hello All,

I have a users audit table (Oracle 8.17's aud$) that I would like to produce a count of how many entries there are for each USERID.

Table: aud$
Field: userid

I have done the below but would take forever to do for all the userid's.
SELECT count(*) FROM aud$ WHERE userid = 'SmithJ';

What can you suggest?

Thanks,

Michael42

 

[PHV]

Something like this ?
SELECT userid, Count(*)
FROM aud$
GROUP BY userid;

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Michael42]

PHV,

Perfect! Thanks for posting.

-Michael42