按价格范围 [英] group by price range

问题描述

说我有一张房地产资料表：

Say I have a table of real estate properties:

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

我想将它们分组0 - 49,999， 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语句中做到这一点？

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

推荐答案

您可以 GROUP BY 表示，例如：

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

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