This guest post comes courtesy of Tony Baer’s OnStrategies blog. Tony is a principal analyst covering Big Data at Ovum. The question was all the more fitting and ironic given the setting — the event ...

Well, if you happen to be using Sql Server you can do that sort of thing in T-Sql. In Oracle, you can also accomplish the same thing using pl/sql. Either way i'd do it in a stored ...

I realized how much easier my life would be if SQL had a mode() aggregate function. (I'm using it in the mathematical sense). I'm guessing that either I use SQL in a wierd way or there is a good ...