in sql

• dhiraj.dubey17

  Grasshopper

  Points: 11

  More actions

  June 28, 2016 at 12:38 am

  #327485

  Hi,

  I have one Requirement

  Example..

  Input-1024000 My required output is 10.24 lac

  Input-99000 My required output is 0.99 lac

  Can anyone please help me on this.

  Thanks in advance.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  June 28, 2016 at 1:35 am

  #1887184

  Where do you need that? In a function? In a SELECT statement?

  Please clarify

  Start here:

  SELECT 1024000 / 100000.0 AS lakhs

  -- Gianluca Sartori