Need to Always Round up in Sql

Name: Need to Always Round up in Sql
Uploaded: 2026-09-29T05:16:11+00:00
Duration: 8 min 45 s
Description: The Decimal Value Needs to Round up to the Nearest Integer, It Doesn't Matter If the Fractional Part Is Greater or Less Than.5. Here Is My Query: Select...

Question

The decimal value needs to round up to the nearest integer, it doesn't matter if the fractional part is greater or less than .5.

Here is my query:

SELECT  MONTH_ 
        , COST 
        , DISC_COST / COST AS 'amount' 
        , DISC_COST 
        , PROFIT  
FROM    arr 
WHERE   MONTH_ LIKE 'JANU%'

These are the result:

MONTH_  COST    amount      DISC_COST   PROFIT
January 200     1              200       70
January 3500    2,414285714    8450     7250
January 4500    1              4500     2900
January 28500   0,631578947    18000    11200
January 600     1              600      100

Accepted Answer

Use CEIL() function (MySQL/Postgres).
Use CEILING() function (MS SQL).

SELECT 
    MONTH_ , 
    COST , 
    CEIL((DISC_COST / COST)) AS 'amount' , 
    DISC_COST , PROFIT  
FROM 
    arr 
WHERE 
    MONTH_ LIKE 'JANU%'

Answer 2

You can use trunc() to make it integer value by just cut off the decimal values.

SELECT MONTH_ , COST , TRUNC(DISC_COST / COST) AS 'amount' , DISC_COST , PROFIT  FROM arr WHERE MONTH_ LIKE 'JANU%'

Need to Always Round up in Sql

2 Answers

Must Read

Your Answer

Sarah Jenkins

Need to Always Round up in Sql

2 Answers

Must Read

Your Answer

Sign up or log in

Post as a guest

Sarah Jenkins