Skip to main content

Return to Answer

Post Timeline

added 4 characters in body
Source Link
Nivesh Krishna
Nivesh Krishna
  • 168
  • 1
  • 8

Median Finding

This is the simplest method to find the median of an attribute.

Select round(S.salary,4) median from employee S where (select count(salary) from station where salary < S.salary ) = (select count(salary) from station where salary > S.salary)

Select round(S.salary,4) median from employee S 
where (select count(salary) from station 
where salary < S.salary ) = (select count(salary) from station
where salary > S.salary)

Median Finding

This is the simplest method to find the median of an attribute.

Select round(S.salary,4) median from employee S where (select count(salary) from station where salary < S.salary ) = (select count(salary) from station where salary > S.salary)

Median Finding

This is the simplest method to find the median of an attribute.

Select round(S.salary,4) median from employee S 
where (select count(salary) from station 
where salary < S.salary ) = (select count(salary) from station
where salary > S.salary)
Source Link
Nivesh Krishna
Nivesh Krishna
  • 168
  • 1
  • 8

Median Finding

This is the simplest method to find the median of an attribute.

Select round(S.salary,4) median from employee S where (select count(salary) from station where salary < S.salary ) = (select count(salary) from station where salary > S.salary)