Home » Other » Training & Certification » URGENT: Calculation query
URGENT: Calculation query Sat, 03 May 2008 11:27
 himesh Messages: 5Registered: May 2008 Junior Member
Hi

I have left my coursework to the last minute and really need your help!

I have created multiple tables and have input data into them, now i have to query one table and perform a vat calculation on one field, the vat value has to be inputted into one of the fields and then the vat taken from the gross total to form the net total, does anybody have a clue how to do this?

this is my table structure

CREATE TABLE Client_orders
(Order_number SMALLINT,
Order_date DATE,
Order_time SMALLINT,
LTC_staff_number SMALLINT,
Client_staff_number SMALLINT,
Discounted_amount NUMERIC(7,2),
Net_order_total NUMERIC(7,2),
VAT NUMERIC(7,2),
Gross_order_total NUMERIC(7,2),
CONSTRAINT Co_pk PRIMARY KEY (Order_number));
Re: URGENT: Calculation query [message #317789 is a reply to message #317788] Sat, 03 May 2008 11:42
 BlackSwan Messages: 26730Registered: January 2009 Location: SoCal Senior Member
>URGENT: Calculation query

Please explain why it is URGENT for me to solve this problem for you.

gross-vat=net; basic primary school mathematics

http://www.orafaq.com/forum/t/88153/0/

[Updated on: Sat, 03 May 2008 11:44] by Moderator

Report message to a moderator

Re: URGENT: Calculation query [message #317790 is a reply to message #317789] Sat, 03 May 2008 11:47
 himesh Messages: 5Registered: May 2008 Junior Member
its urgent because as i stated in the topic, i have left it to the last minute.

is there not a special code? like select from.....
Re: URGENT: Calculation query [message #317791 is a reply to message #317790] Sat, 03 May 2008 11:50
 Michel Cadot Messages: 67284Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator
The only thing that is urgent is that you read and follow OraFAQ Forum Guide.

Regards
Michel
Re: URGENT: Calculation query [message #317792 is a reply to message #317788] Sat, 03 May 2008 11:51
 BlackSwan Messages: 26730Registered: January 2009 Location: SoCal Senior Member
>this is my table structure
This appears to be for MYSQL & not Oracle.

http://www.orafaq.com/forum/t/88153/0/