Distinct Count? 1

[azwaan]

i basically want to get a count of all distinct values in a specific column.

i have the following statement which returns unique tranid's . distinct clause is necessary cos table contains duplicate tranid's.

"select distinct tranid from temptransactions"

how do i get a count of these fields? Distinct Count?

 

[vongrunt]

count( distinct tranid )

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)