Explore a Few Math Functions in SQL Server

There are a number of math functions in T-SQL. Here are a few of them:

SELECT SQRT(49) --Gives 7, Square RootSELECT PI() --Gives 3.14 .... PISELECT ROUND(15.30, 0) --Gives 15. Rounds a numberSELECT CEILING(49.32) --Gives 50. Finds the next highest Integer valueSELECT FLOOR(49.32) --Gives 49. Finds the next lowest Integer value
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

More From DevX