Javatpoint Logo
Javatpoint Logo

PI Function in SQL

The PI() is a mathematics function which returns the pi value. In this section you will also learn how to use round function with the PI function.

In Structured Query Language, this function does not take any argument.

Syntax of PI Function

In this SELECT syntax, we have to pass that numeric number in the function whose tan value we want to find.

Examples of PI function

Example 1: This example returns the pi value of the specified number:

Output:

pi_plus8
11.145926535897931

Example 2: This example returns the pi value of the specified number:

Output:

pi
3.145926535897931

Example 3: This example returns the pi value representation of 19:

Output:

pi_plus2
5.1415926535897931

Example 4: This example returns the pi value of the specified number:

Output:

pi_multiply10
31.415926535897931

Example 5: The following example uses the ROUND function with the PI function:

Output:

New_RoundOFF
3.14199999999999999

Example 6: This example returns the pi value of the specified number after division:

Output:

pi_division2
1.5707963267948966






Youtube For Videos Join Our Youtube Channel: Join Now

Feedback


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Preparation


Trending Technologies


B.Tech / MCA