0
I want to put the result of this equation there where is 'RESULT1' I tried to do
result1 = x
But it didn’t work, I have little experience with SQL yet;
SELECT (VA * VB) / VC
FROM (SELECT 5 AS VA, 10 AS VB, 5 AS VC, X AS RESULT1 FROM DUAL UNION
SELECT 1 AS VA, 1 AS VB, 1 AS VC, X AS RESULT1 FROM DUAL UNION
SELECT 3 AS VA, 10 AS VB, 2 AS VC, X AS RESULT1 FROM DUAL);
I tried to do so,
SELECT RESULT1 = (VA * VB) / VC
FROM (SELECT 5 AS VA, 10 AS VB, 5 AS VC, X AS RESULT1 FROM DUAL UNION
SELECT 1 AS VA, 1 AS VB, 1 AS VC, X AS RESULT1 FROM DUAL UNION
SELECT 3 AS VA, 10 AS VB, 2 AS VC, X AS RESULT1 FROM DUAL);
Thanks more I’ve solved
– Pedro Alencar