According to this link
, DB2 does not offer the "Median" function that is available in MS-Excel for instance.
Does anyone know of an alternative method that I could run in my query to produce the "Median" result? The SQL below better demonstrates what I'm looking to achieve if "Median" was actually a function that was available to me.
Select FIELD1, Median([FIELD2])
Group by FIELD1