如何在MySQL中查询四分位数1、2和3？

admin

我有一个查询四分位数的方法，如下所示：

cast(substring_index(substring_index(group_concat(`lulusanmagisterrangkuman`.`IPK` 
    order by `lulusanmagisterrangkuman`.`IPK` ASC separator ','),',',(((50 / 100) * count(0)) + 1)),',',-(1)) as decimal(10,0)) AS `Median`,
cast(substring_index(substring_index(group_concat(`lulusanmagisterrangkuman`.`IPK` 
    order by `lulusanmagisterrangkuman`.`IPK` ASC separator ','),',',(((25 / 100) * count(0)) + 1)),',',-(1)) as decimal(10,0)) AS `Q1`,
cast(substring_index(substring_index(group_concat(`lulusanmagisterrangkuman`.`IPK` 
    order by `lulusanmagisterrangkuman`.`IPK` ASC separator ','),',',(((75 / 100) * count(0)) + 1)),',',-(1)) as decimal(10,0)) AS `Q3`

但是这个源代码不适用于浮点值。当我尝试这些代码时，返回的值是一个整数。我该怎么做才能看到整型或浮点型的四分位数呢？提前感谢

转载请注明出处:http://www.cjhyc.com/article/20230526/1822623.html