sql question

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

Try this:

select salary * 0.75 salary from your_table;

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

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

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


HTH.

or ..

Code:

---

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

---

slimdave

this is exactly the one i look for

thank u all