Interactive SQL

For Insert SQL For Update SQL For Select SQL For Delete SQL Learn Programmer
Level SQL

SQL Fundas

SQL Select SQL Insert SQL Update SQL Delete SQL Distinct SQL Where SQL And & Or SQL Order By SQL Data Types SQL Cross Join SQL Inner Join SQL Left Join SQL Right Join SQL Full Join SQL Self Join SQL Union SQL Top SQL Like SQL Wildcards SQL In SQL Between SQL Alias SQL Select Into SQL Create Table SQL Drop SQL Alter SQL Constraints SQL Not Null SQL Unique SQL Primary Key SQL Foreign Key SQL Check SQL Default SQL Create Index SQL Identity SQL Views SQL Dates SQL Nulls SQL IsNull() SQL NullIf() SQL Create DB

SQL Functions

SQL Functions SQL Count() SQL Sum() SQL Min() SQL Max() SQL Len() SQL Round() SQL Upper() SQL Lower() SQL Avg() SQL Group By SQL Having SQL PatIndex() SQL Substring() SQL Sqrt() SQL Rand() SQL Concat()

SQL - SQRT Function

« Previous Chapter

Next Chapter »

SQL Tutorial - SQL SQRT Function

The SQRT function is used to get the square root of any number.

SQL SQRT() SYNTAX

Select SQRT();

The SQRT Function Example

Select SQRT(16) as SquareRoot;

Here the input parameter is 16.

SquareRoot

4

Consider the Products table which has the following records:

ProductID	ProductName	ProductPrice
Prd001	Pen	40.25
Prd002	Pen	100.75
Prd003	Eraser	10.35
Prd004	Pencil	20.45
Prd005	Book	50.65
Prd006	Gum	25.22

To calculate the square root of all the prices of the products, use the Sqrt function on the ProductPrice column as shown below.

SELECT ProductName, SQRT(ProductPrice) SqrtPrice FROM Products;

ProductName	SqrtPrice
Pen	6.34428877022476
Pen	10.0374299499424
Eraser	3.21714158842908
Pencil	4.52216762183801
Book	7.11688133946323
Gum	5.02195181179589

« Previous Chapter

Next Chapter »