sql maths:price / ? --> one decimal before the last digit

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  October 9, 2009 at 3:16 pm

  #136491

  All,

  I have something different scenario.

  select 000031761

  select 000000500

  select 000000005

  select 000008724

  i need the output like

  3176.1

  50.0

  0.5

  872.4

  Inputs are welcome!

  karthik

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  October 9, 2009 at 3:20 pm

  #1064373

  select x= 000031761*0.1

  Results:

  x

  ---------

  3176.1