Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    2

    Unanswered: select statement

    I need to write a select statement that will do the below calculation
    unit price * quantity - discount
    unit price = 9.8
    quantity = 30
    discount = 0.15
    Any help will be greatly welcome! Thanks.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what have you tried so far?
    what SQL engine are you using?

    is the discount limited to rows just with those values?

    on the face of it
    select (9.8*3-0.15) as DiscountedPrice from <mytablename>
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •