Jump to content

SQL total help


1nstan7

Recommended Posts

Here is an example:quantity | Price | Total_order_price6 $6 $36I have created the quantity and price SQL:CREATE TABLE Ordered_Aircraft(quantity NUMBER(4),price Currency(4));Do I need to make one for total_order_price? If so how do I make it so it get the total price (quantity x Price)

 

Between this is an example. I am trying to get total_order_price from quantity and price, how would I do that?

Edited by 1nstan7
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...