TOPIC

MEU RACIOCÍNIO ESTÁ NO CAMINHO CERTO?

Yago Pereira Coelho asked 5 months 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

This topic has not been answered yet. Be the first!

Remember not post solutions. Your post may be reviewed by our moderators.