sql - 如何选择TOP 50 PERCENT的MIN值？(How to Select MIN value of TOP 50 PERCENT?)

Question

I am find the 50th percentile of a group of salaries.

(我找到了一组薪水的第50个百分点。)

How can I select the MIN value of the Top 50 percent of a group of data?

(如何选择一组数据的前50％的MIN值？)

Here is the syntax I have that fails:

(这是我失败的语法：)

SELECT MIN(SELECT TOP 50 PERCENT [PrimaryCompensationBasis-Amount(USD)])
FROM qryEEGroup;

Thanks!

(谢谢！)

  ask by Chris2015 translate from so

Answer 1

Try to use nested select statement:

(尝试使用嵌套的select语句：)

SELECT MIN([PrimaryCompensationBasis-Amount(USD))
FROM (SELECT TOP 50 PERCENT [PrimaryCompensationBasis-Amount(USD)] FROM qryEEGroup ORDER BY [PrimaryCompensationBasis-Amount(USD)]) tab;