The Kubera Principle

The Book That Will Change the World

# Question-190:: Write an SQL query to calculate the median salary of employees?

WITH MedianSalary AS (
SELECT salary, PERCENTILE_CONT(0.5) WITHIN GROUP
(ORDER BY salary) OVER () AS median
FROM employee_details
)
SELECT DISTINCT median
FROM MedianSalary;

@SekharAcademy1

#sql
#sqlqueries
#mysql
#oracle
#learning
#interview
#programming
#database
#education
#sqlinterview
#interviewquestions
#quiz
#sqlquiz
#quiztest
#test
#interviewtest
#mcq
#mocktest
#viralvideo
#video #viralshorts
#trending #viralreels
#follow #sqljoins
#join #interviewquery
#leetcode #leetcodesql
#leetcodesolutions #job
#jobs #jobsearch #olympics
#databasequeries
#leetcode #leetcodesolutions
#leetcodesql #coding
#sqlinterviewquestionsandanswers
#sqlforbeginners
#sqlinterviewquestions
#sqlqueryinterviewquestionsandanswers
#interview
#education
#mysql questions asked in interview
#mysql uestionsaskedininterview
#sql tricky interview questions and answers
#sqltrickyinterviewquestionsandanswers
#sql senario interview questions and answers
#sqlsenariointerviewquestionsandanswers
#sql interview videos
#sqlinterviewvideos
#sql interview questions and answers in english
#sqlinterviewquestionsandanswersinenglish
#sql queries for java interview
#sqlqueriesforjavainterview
#interview questions for
#interviewquestionsfor
#sqldatascientiestinterviewquestions
#sql data scientiest interview questions
#top 50 interview questions on sql
#top50interviewquestionsonsql
#dataanalutics
#data
#sql interview questions for testing
#sql interview questions and answers for join
#sqlinterviewquestionsandanswersforjoin
#join in sql
#Joininsql
#functionsinsql