Sunday , June 16 2024

CEILING Function in SQL Server(TSQL)


The CEILING function returns the smallest integer value greater than a number. If the number is already an integer, it returns the same number as the result. The return data type is the data type of the input parameter.

Below you can see how the CEILING function behaves at different values.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *