How to create columns Computations in the Query Results.
The select_list is the place where you can create computations that you want to be performed on any of the numeric data or constants.
Symbols to use for this:
MySQL, Oracle, SQL server, PostgreSQL:
select Order_ID as "Order", ISBN_no as "ISBN", Item_qty "Quantity", price "Price", Item_qty*price "Product" from order_BOOKS where order_ID=70001;
The result should be:
© 2010 by Finnesand Data. All rights reserved.
This site aims to provide FREE programming training and technics.
Finnesand Data as site owner gives no warranty for the
correctness in the pages or source codes.
The risk of using this web-site pages or any program
codes from this website is entirely at the individual user.