Re: Specialised Counts

"Mark Starmer" wrote...
> Is there a way (perhaps using nested SQL) to count the number of
> occurances of each distinct record ie
>
> Input
> -----
> John
> John
> John
> Jim
>
> Output
> ------
> John - 3
> Jim -1
>
> Thanks a lot
>
> M Starmer

Hi Mark,

do you mean something like
'select input, count(*) from <yourtable>  group by input'?

Or did I totally miss the point?

hth,
Guido Received on Fri Apr 04 2003 - 04:38:23 CST