#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2013
    Posts
    30
    Rep Power
    2

    Question Display a list of all book titles along with their percentage of markup


    I've gotten it to display the percentage of markup correctly(as in, multiplied by 100 with no decimal places), but I cannot for the life of me get the percentage sign to display on the right of the values(i.e. 40, but not 40%).

    Here's my code so far:
    Code:
    SELECT title, to_char(round((retail-cost)/retail*100), '99') 
    AS "MARKUP %" FROM BOOKS;
    I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.

    Nvm, managed to get it to work. Will post my solution soon.
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Sep 2006
    Posts
    854
    Rep Power
    387

    Wink


    Originally Posted by darthvader45
    I've gotten it . . . E t c . . .
    I've tried concatenating with both the + sign and the ampersand (&) sign, to no avail.
    Perhaps you could try using the "Oracle" concatenating symbol (function)?

IMN logo majestic logo threadwatch logo seochat tools logo