Home » Other » Training & Certification » URGENT: Calculation query
URGENT: Calculation query [message #317788] Sat, 03 May 2008 11:27 Go to next message
himesh
Messages: 5
Registered: 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 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
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/
Please read & FOLLOW posting guidelines as stated above

[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 Go to previous messageGo to next message
himesh
Messages: 5
Registered: 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 Go to previous messageGo to next message
Michel Cadot
Messages: 59279
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account 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 Go to previous messageGo to next message
BlackSwan
Messages: 22839
Registered: January 2009
Senior Member
>this is my table structure
This appears to be for MYSQL & not Oracle.

http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW posting guidelines as stated above
Re: URGENT: Calculation query [message #317797 is a reply to message #317788] Sat, 03 May 2008 13:26 Go to previous message
Barbara Boehmer
Messages: 7990
Registered: November 2002
Location: California, USA
Senior Member
Since your table structure appears to be MySQL and not Oracle and this is an Oracle forum, not a MySQL forum, you should post your problem on a MySQL forum, like perhaps one of the following or any others that you might find searching the web using Google or whatever search tool you prefer:

http://pipetalk.quest-pipelines.com/default.asp?boardid=mysql

http://forums.mysql.com/
Previous Topic: UPDATE sql statement help please
Next Topic: Group by having
Goto Forum:
  


Current Time: Tue Sep 30 15:11:39 CDT 2014

Total time taken to generate the page: 0.05914 seconds