按价格范围分组

本文介绍了按价格范围分组的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

假设我有一张房地产表:

Say I have a table of real estate properties:

A  15,000
B  50,000
C 100,000
D  25,000

我想将它们按 0 - 49,999、50,000 - 99,999 和 100,000 - 200,000 分组

I'd like to group them by 0 - 49,999, 50,000 - 99,999 and 100,000 - 200,000

所以结果应该是:

   0 -  49k (2)
 50k -  99k (1)
100k - 200k (1)

有没有办法在一个 SQL 语句中做到这一点?顺便说一下，我正在使用 Postgres.

Is there a way to do that in one SQL statement? I'm using Postgres by the way.

你可以GROUP BY一个表达式，类似这样:

You can GROUP BY an experession, something like that:

SELECT price/50000*50000 AS minPrice,
    (price/50000+1)*50000-1 AS maxPrice,
    COUNT(*)
FROM table
GROUP BY price/50000;

这篇关于按价格范围分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！