dcsimg
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


Tip of the Day
Language: SQL
Expertise: Beginner
Jun 17, 2019

WEBINAR:

On-Demand

Building the Right Environment to Support AI, Machine Learning and Deep Learning


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 Root

SELECT PI() --Gives 3.14 .... PI

SELECT ROUND(15.30, 0) --Gives 15. Rounds a number

SELECT CEILING(49.32) --Gives 50. Finds the next highest Integer value

SELECT FLOOR(49.32) --Gives 49. Finds the next lowest Integer value
Hannes du Preez
 
Thanks for your registration, follow us on our social networks to keep up-to-date