Doesn't seem to work on IBM I's DB2 variant.

https://www.ibm.com/developerworks/community/blogs/SQLTips4DB2LUW/entry/how_to_do_median_in_db253?lang=en

Get syntax error at (

Presumably because of count(1) over()

Not sure what to use for alternative syntax however.




Return to Archive home page | Return to MIDRANGE.COM home page