SQL - Calculating the MODE

[boycee]

Ok.. Calculating the average value (MODE) (Most common) in a column (part of a larger query)

STATS_MODE

Was nice, but turns out the stupid legacy DB doesn't support this argument.

Anyone know of a nice way to do it?

 

[boycee]

Oracle, but I think it's vs9 ish...