|
1 |
ABS( number ) |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14 |
ABS(-23)Result: 23ABS(-23.6)Result: 23.6ABS(-23.65)Result: 23.65ABS(23.65)Result: 23.65ABS(23.65 * -1)Result: 23.65 |
|
1 |
ACOS( number ) |
|
1
2
3
4
5
6
7
8 |
ACOS(0.2)Result: 1.36943840600457ACOS(0.35)Result: 1.21322522314939ACOS(-0.15)Result: 1.72136459957158 |
|
1 |
ASIN( number ) |
|
1
2
3
4
5
6
7
8 |
ASIN(0.2)Result: 0.201357920790331ASIN(0.35)Result: 0.35757110364551ASIN(-0.15)Result: -0.150568272776686 |
|
1 |
ATAN( number ) |
|
1
2
3
4
5
6
7
8 |
ATAN(0.2)Result: 0.197395559849881ATAN(0.35)Result: 0.336674819386727ATAN(-0.15)Result: -0.148889947609497 |
|
1 |
ATAN2( n, m ) |
|
1
2
3
4
5
6
7
8 |
ATAN2(0.2, 0.3)Result: 0.588002603547568ATAN2(0.35, -0.15)Result: 1.97568811307998ATAN2(-0.3, -0.4)Result: -2.49809154479651 |
|
1 |
CEIL( number ) |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14 |
CEIL(32.65)Result: 33CEIL(32.1)Result: 33CEIL(32)Result: 32CEIL(-32.65)Result: -32CEIL(-32)Result: -32 |
|
1 |
COS( number ) |
|
1 |
COSH( number ) |
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14 |
COSH(0.2)Result: 1.02006675561908COSH(0.35)Result: 1.06187781915599COSH(-3.15)Result: 11.6894583539049COSH(200)Result: 3.61298688406287E86COSH(0)Result: 1 |
|
1
2
3 |
SELECT COUNT(aggregate_expression)FROM tables[WHERE conditions]; |
|
1
2
3
4
5
6
7
8
9
10
11
12
13 |
SELECT COUNT(supplier_id)FROM suppliers;Result: 3SELECT COUNT(state) FROM suppliers;Result: 1SELECT COUNT(DISTINCT department) AS "Unique departments"FROM employeesWHERE salary > 55000; |
|
1 |
FLOOR( number ) |
|
1
2
3
4
5
6
7
8 |
FLOOR(5.9)Result: 5FLOOR(34.29)Result: 34FLOOR(-5.9)Result: -6 |
