sql question

[hsbdba]

Hi,

I am trying to cretae a query showing my employees salary *0.75
my request is how to show the new value to the higher 10 real number ,

for example salary = 1750
salary * 0.75 = 1312.50

i need to show the new salary as 1320.

Regards

Working together helping each other

[AOrehek]

Try this:

select salary * 0.75 salary from your_table;

[hsbdba]

Thanks for your reply

but if i select salary*0.75 from my table

salary * 0.75 = 1312.50

I need to profuce it as 1320

[hsbdba]

Hi,

I need the experts to put hands please,

is it too complicated ??

just want to go up to higer 10 value
instead of get 1312.20 1320
1337 1340
1511 1520
is it possible


regards

[patel_dil]

select sal + (10 - mod(trunc(sal), 10)) from
(select trunc(salary * .75) sal from salary_table)


HTH.

[slimdave]

or ..

Select
   Round((salary*0.75)+4.9999,-1) sal
From
   salary_table

[hsbdba]

slimdave

this is exactly the one i look for

thank u all