SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
CREATE TABLE bigdata (category varchar, feature_a int, feature_b int); INSERT INTO bigdata VALUES ('top20', 3, 5), ('top10', 2, 6), ('top10', 1, 7), ('top20', 4, 8); SELECT 'feature_a', SUM(CASE WHEN category = 'top10' THEN feature_a ELSE 0 END) "TOP10", SUM(CASE WHEN category = 'top10' THEN feature_a ELSE 0 END) "TOP20" FROM bigdata
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear