Home > Archive > PostgreSQL SQL > November 2006 > Correct Select Syntax?









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Correct Select Syntax?
Kojak

2006-11-14, 7:19 pm

What is the correct syntax for the following (which I know doesn't
work)?
select (<some long calculation> as
cost)- (cost*discount_rate)
+(cost*tax_rate) from ......

I don't want to have to calculate the value of cost, then do it again
to figure out the discount amount, and then do it again for the tax
amount.

Is this possible?

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com