SQL Tutorial
5. 图瓦卢
Selected Reading
- SQL - Discussion
- SQL - Useful Resources
- SQL - Useful Functions
- SQL - Quick Guide
- SQL - Questions and Answers
- SQL - Datatype Functions
- SQL - Conversion Functions
- SQL - JSON Functions
- SQL - Cursor Functions
- SQL - Logical Functions
- SQL - Statistical Functions
- SQL - Text & Image Functions
- SQL - Numeric Functions
- SQL - Aggregate Functions
- SQL - String Functions
- SQL - Date Functions
- SQL - Database Tuning
- SQL - IN vs EXISTS
- SQL - Group By vs Order By
- SQL - Common Table Expression
- SQL - Cursors
- SQL - Date & Time
- SQL - Auto Increment
- SQL - Using Sequences
- SQL - Handling Duplicates
- SQL - Sub Queries
- SQL - Transactions
- SQL - NULL Values
- SQL - Stored Procedures
- SQL - Default Constraint
- SQL - Check Constraint
- SQL - Null Functions
- SQL - Min & Max
- SQL - Hosting
- SQL - Injection
- SQL - Comments
- SQL - Wildcards
- SQL - Non-Clustered Index
- SQL - Clustered Index
- SQL - Unique Index
- SQL - Primary Key
- - 工会诉Join
- SQL - Inner Join
- SQL - Using Joins
- SQL - Aliases
- SQL - EXCEPT Operator
- SQL - INTERSECT Operator
- SQL - UNION vs UNION ALL
- SQL - UNION Operator
- SQL - BETWEEN Operator
- SQL - NOT NULL
- SQL - IS NOT NULL
- SQL - IS NULL
- SQL - NOT EQUAL
- SQL - NOT Operator
- SQL - CASE
- SQL - EXISTS Operator
- SQL - ANY, ALL Operators
- SQL - IN Operator
- SQL - LIKE Operator
- SQL - BOOLEAN (BIT) Operator
- SQL - AND & OR
- SQL - Having Clause
- SQL - Group By Clause
- SQL - Order By Clause
- SQL - Distinct Clause
- SQL - Top Clause
- SQL - Where Clause
- SQL - Rename Views
- SQL - Drop Views
- SQL - Update Views
- SQL - Create Views
- SQL - Sorting Results
- SQL - Delete Query
- SQL - Update Query
- SQL - Insert Into Select
- SQL - Select Into
- SQL - Select Query
- SQL - Insert Query
- SQL - Constraints
- SQL - Delete Table
- SQL - Drop Table
- SQL - Alter Tables
- SQL - Temporary Tables
- SQL - Clone Tables
- SQL - Truncate Table
- SQL - Rename Table
- SQL - Show Tables
- SQL - Create Table
- SQL - Backup Database
- SQL - Show Database
- SQL - Rename Database
- SQL - Select Database
- SQL - Drop Database
- SQL - Create Database
- SQL - Expressions
- SQL - Operators
- SQL - Data Types
- SQL - Syntax
- SQL - Databases
- SQL - RDBMS Concepts
- SQL - Overview
- SQL - Home
5. 图瓦卢
- 页: 1
- 页: 1
- 结构-创建指数
- 页: 1
- 页: 1
- 页: 1
- SQL - Foreign Key
- 文 件
- ∗ E/CN.6/2009/1。
- 页: 1
- 页: 1
- 文 件
- 页: 1
- 页: 1
- 文 件
- 页: 1
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
SQL - Numeric Functions
SQL - Numeric Functions
SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions −
| Sr.No. | Function & Description |
|---|---|
| 1 |
Returns the absolute value of numeric expression. |
| 2 |
Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to 1. |
| 3 |
Returns the arcsine of numeric expression. Returns NULL if value is not in the range -1 to 1 |
| 4 |
Returns the arctangent of numeric expression. |
| 5 |
Returns the arctangent of the two variables passed to it. |
| 6 |
Returns the smallest (closest to negative infinity) integer value that is greater than or equal to this value. |
| 7 |
Returns the trigonometric cosine of the given value. |
| 8 |
Returns the trigonometric cotangent of the given value. |
| 9 |
Returns numeric expression converted from radians to degrees. |
| 10 |
Returns the base of the natural logarithm (e) raised to the power of passed numeric expression. |
| 11 |
Returns the largest integer value that is not greater than passed numeric expression. |
| 12 |
Returns the natural logarithm of the passed numeric expression. |
| 13 |
Returns the base-10 logarithm of the passed numeric expression. |
| 14 |
Returns the value of pi |
| 15 |
Returns the value of one expression raised to the power of another expression |
| 16 |
Returns the value of passed expression converted from degrees to radians. |
| 17 |
Returns the random value between 0 and 1. |
| 18 |
Returns numeric expression rounded to an integer. Can be used to round an expression to a number of decimal points |
| 19 |
Returns the sign of a number, indicating whether it is positive, negative, or zero. |
| 20 |
Returns the sine of numeric expression given in radians. |
| 21 |
Returns the non-negative square root of numeric expression. |
| 22 |
Returns the tangent of numeric expression expressed in radians. |