Posted By

daipratt on 10/02/10

Tagged

mysql

Versions (?)

Last Edited at 10/02/10 05:18am

Statistics

Viewed 2794 times

Favorited by 1 user(s)

Related snippets

MySQL - Group by price range

/ Published in: MySQL

Group by user defined price bands.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

SELECT price_range, count(*) AS num
FROM
(select case when product_price >= 150 and product_price <= 249.99 then '150-249.99'
             when product_price >= 250 and product_price <= 299.99 then '250-299.99'
             when product_price >= 300 and product_price <= 399.99 then '300-399.99'
             when product_price >= 400 and product_price <= 499.99 then '400-499.99'
             when product_price >= 500 and product_price <= 999.99 then '500-999.99'
             else 'over 1000'
         end as price_range
FROM washing_machines
WHERE 1
) AS  price_summaries
GROUP BY price_range

URL: http://daipratt.co.uk/tag/mysql/

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.