j.taylor Posted August 16, 2017 Share Posted August 16, 2017 My query below gives several rows in the output html table that contain the word "infancy" and a value. How do I combine all of these into one row with a total, while keeping that row ordered with all the others? So, instead of: 5 | 15 75 | 7 infancy | 4 66 | 3 infancy | 2 I'd get: 5 | 15 75 | 7 infancy | 6 66 | 3 $sql = "SELECT age, COUNT(age) AS frequency, CASE WHEN age = 'inf.' THEN 'infancy' WHEN age = '1' THEN 'infancy' WHEN age LIKE ('%mos.') THEN 'infancy' WHEN age LIKE ('%wks.') THEN 'infancy' ELSE age END AS age FROM persons WHERE age IS NOT NULL AND age <> '' AND age <> '?' GROUP BY age ORDER BY frequency DESC, age DESC LIMIT 100"; Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.