Remove Decimal Values Using SQL Query

Remove decimal values using SQL query

Since all your values end with ".00", there will be no rounding issues, this will work

SELECT CAST(columnname AS INT) AS columnname from tablename

to update

UPDATE tablename
SET columnname = CAST(columnname AS INT)
WHERE .....

Removing decimals in SQL Query

You can try:

CONVERT(INT, Max(CashTrans.Costprice))

Remove decimal using SQL query

Try with the below script..

cast (100 * Round((sample1 / sample2),2) As int ) as 'Percent'

Remove Decimal from Alphanumeric Field

Use the REPLACE function to replace all decimal points with an empty string ''.

SELECT REPLACE(icd10, '.', '') as icd10 FROM T

SQL Format as of Round off removing decimals

use ROUND () (See examples ) function in sql server

select round(11.6,0)

result:

12.0

ex2:

select round(11.4,0)

result:

11.0

if you don't want the decimal part, you could do

select cast(round(11.6,0) as int)

db2: how to remove the decimal from number column?

casting this value should just work:

select cast(avg(price) as int) as avg_int
from cars 
where type = 'electric';

How to remove decimal digit from result in mysql?

1. If you want to round off decimal places, use ROUND(yourColumn,0) function.

   So 13.78 will become 14

2. If you want to get rid of decimal places, user FLOOR(yourColumn)

   So 13.78 will become 13

So for example

SUM(TIMESTAMPDIFF(MINUTE,Request_Date, Xetr))/60 AS WH

should be changed to

ROUND(SUM(TIMESTAMPDIFF(MINUTE,Request_Date, Xetr))/60,0) AS WH

Edit: This would take care of your %.

CONCAT(
        ROUND(count(CASE
            WHEN STATUS = 'PENDING' THEN 1
            ELSE NULL
        END) * 100 / count(1),0)
        , '%') AS PC

Do the same for all the columns you need to remove decimal places.

---

Related Topics