Re: Temp field or variable

[pearsojd]

Hi,

Just depends on what attributes you have. Eg you have a table containing `order_amount` and `cost`

select (order_amount * cost) as total from my_table order by total;

It depends how you want it `ordered`. The above example will be ascending order or use `order by total desc` for descending order.

James.