Good one, covers the basic and most used functions. I always wonder, generally, the list doesn't have a MEDIAN function. I use SQL Server, they have introduced PERCENTILE_CONT starting from SQL Server 2012. Just a thought, should MEDIAN be also a part of the list
Good one, covers the basic and most used functions. I always wonder, generally, the list doesn't have a MEDIAN function. I use SQL Server, they have introduced PERCENTILE_CONT starting from SQL Server 2012. Just a thought, should MEDIAN be also a part of the list
Agreed, PERCENTILE_CONT is a handy function of later SQL Server editions.
I'll be diving into this and the more complex functions that need an OVER ( [ ] ) in the next post. :)