且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

按价格范围分组

更新时间:2023-11-30 10:48:40

你可以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;