TEMA
MEU RACIOCÍNIO ESTÁ NO CAMINHO CERTO?
ypcoelho preguntado 2 years ago
ESTOU SEGUINDO ESSA IDEIA. ESTA CERTA?MAS DÁ 100 WRONG
SELECT from (SELECT products.name AS type,CAST(round((products.price+20.0),1)AS NUMERIC(10,1))AS price from products WHERE products.type='A' ORDER BY products.id) as a UNION ALL SELECT from (SELECT products.name AS type,CAST(round((products.price+70.0),1) AS NUMERIC(10,1)) AS price from products WHERE products.type='B' ORDER BY products.id) as b UNION ALL SELECT * from (SELECT products.name AS type,CAST(round((products.price+530.533),1) AS NUMERIC(10,1)) AS price from products WHERE products.type='C' ORDER BY products.id) as c