Calculate Median In MS SQL Server

In MS SQL Server, there is no median function and there is no direct way to calculate the median value. However if you’re using SQL Server 2012 or later, we can easily calculate the median using the PERCENTILE_DISC OR PERCENTILE_CONT functions.

► Buy Me a Coffee? Your support is much appreciated!
——————————————————————————————-
☕ Paypal: https://www.paypal.me/jiejenn/5
☕ Venmo: @Jie-Jenn
💸 Join Robinhood with my link and we’ll both get a free stock: https://bit.ly/3iWr7LC

► Support my channel so I can continue making free contents
—————————————————————————————————————
🌳 Becoming a Patreon supporter: https://www.patreon.com/JieJenn
🛒 By shopping on Amazon → https://amzn.to/2JkGeMD
📘 Facebook Page → https://www.facebook.com/MadeInPython/
📘 More tutorial videos on my website → https://LearnDataAnalysis.org
👩‍💻 Follow me on Linked: https://www.linkedin.com/in/jiejenn/
✉️ Business Inquiring: [email protected]

#SQLServer