How to find Median in SQL Database

Since median is harder than min/max/count and not a standard aggregate function, we’ll need to do a little more work to calculate it. Here’s how on several different databases: Median on Redshift The Redshift team recently released a median window fu...