Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
ElevateDB Technical Support
»
Support Forums
»
ElevateDB SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
use value of column for another column
Sat, Jan 22 2022 7:56 AM
Permanent Link
Robert Perelegre
Hi
Can I do something like this ?
SELECT Codi_Article, Preu, ROUND(Preu * 1.21, 2) AS PREU_IGI, PREU_IGI - 0.5 AS PREU_DTE
FROM Tarifes
Regards
Robert
Sat, Jan 22 2022 9:20 AM
Permanent Link
Fernando Dias
Team Elevate
Robert,
No.
What you can do instead is:
SELECT
Codi_Article, Preu, ROUND(Preu * 1.21, 2) AS PREU_IGI, ROUND(Preu * 1.21, 2) - 0.5 AS PREU_DTE
FROM
Tarifes
--
Fernando Dias
[Team Elevate]