Carview!

VEHICLES
BRAND
- JAPANESE CARS
  - DAIHATSU
  - EUNOS
  - FORD
  - HONDA
  - ISUZU
  - LEXUS
  - MAZDA
  - MITSUBISHI
  - MITSUOKA
  - NISSAN
  - SUBARU
  - SUZUKI
  - TOYOTA
- GERMAN CARS
- AMERICAN CARS
- BRITISH CARS
- ITALIAN CARS
- FRENCH CARS
- SWEDISH CARS
- KOREAN CARS
TYPE
- mobility
- VENDING
- instruction
- TAXIS
- AMBULANCES
- FIRE ENGINES
- HEARSES
- LIMOUSINES
- COMMERCIAL
CLASS
FUEL
TRUCKS
minitrucks
- DAIHATSU
- HONDA
- MAZDA
- MITSUBISHI
- NISSAN
- SUBARU
- SUZUKI
- DUMP
- CRANE
- CAMPER
- REFRIGERATED
- 4WD
- NEW
BUSES
MOTORHOMES
- YAHOO!
- RAKUTEN
- DEALER

Operator	Description	Example	Result
`+`	Addition	`2 + 3`	`5`
`-`	Subtraction	`2 - 3`	`-1`
`*`	Multiplication	`2 * 3`	`6`
`/`	Float division	`5 / 2`	`2.5`
`//`	Division	`5 // 2`	`2`
`%`	Modulo (remainder)	`5 % 4`	`1`
`**`	Exponent	`3 ** 4`	`81`
`^`	Exponent (alias for `**`)	`3 ^ 4`	`81`
`&`	Bitwise AND	`91 & 15`	`11`
`\|`	Bitwise OR	`32 \| 3`	`35`
`<<`	Bitwise shift left	`1 << 4`	`16`
`>>`	Bitwise shift right	`8 >> 2`	`2`
`~`	Bitwise negation	`~15`	`-16`
`!`	Factorial of `x`	`4!`	`24`

Name	Description
`@(x)`	Absolute value. Parentheses are optional if `x` is a column name.
`abs(x)`	Absolute value.
`acos(x)`	Computes the inverse cosine of `x`.
`acosh(x)`	Computes the inverse hyperbolic cosine of `x`.
`add(x, y)`	Alias for `x + y`.
`asin(x)`	Computes the inverse sine of `x`.
`asinh(x)`	Computes the inverse hyperbolic sine of `x`.
`atan(x)`	Computes the inverse tangent of `x`.
`atanh(x)`	Computes the inverse hyperbolic tangent of `x`.
`atan2(y, x)`	Computes the inverse tangent of `(y, x)`.
`bit_count(x)`	Returns the number of bits that are set.
`cbrt(x)`	Returns the cube root of the number.
`ceil(x)`	Rounds the number up.
`ceiling(x)`	Rounds the number up. Alias of `ceil`.
`cos(x)`	Computes the cosine of `x`.
`cot(x)`	Computes the cotangent of `x`.
`degrees(x)`	Converts radians to degrees.
`divide(x, y)`	Alias for `x // y`.
`even(x)`	Round to next even number by rounding away from zero.
`exp(x)`	Computes `e ** x`.
`factorial(x)`	See the `!` operator. Computes the product of the current integer and all integers below it.
`fdiv(x, y)`	Performs integer division (`x // y`) but returns a `DOUBLE` value.
`floor(x)`	Rounds the number down.
`fmod(x, y)`	Calculates the modulo value. Always returns a `DOUBLE` value.
`gamma(x)`	Interpolation of the factorial of `x - 1`. Fractional inputs are allowed.
`gcd(x, y)`	Computes the greatest common divisor of `x` and `y`.
`greatest_common_divisor(x, y)`	Computes the greatest common divisor of `x` and `y`.
`greatest(x1, x2, ...)`	Selects the largest value.
`isfinite(x)`	Returns true if the floating point value is finite, false otherwise.
`isinf(x)`	Returns true if the floating point value is infinite, false otherwise.
`isnan(x)`	Returns true if the floating point value is not a number, false otherwise.
`lcm(x, y)`	Computes the least common multiple of `x` and `y`.
`least_common_multiple(x, y)`	Computes the least common multiple of `x` and `y`.
`least(x1, x2, ...)`	Selects the smallest value.
`lgamma(x)`	Computes the log of the `gamma` function.
`ln(x)`	Computes the natural logarithm of `x`.
`log(x)`	Computes the base-10 logarithm of `x`.
`log10(x)`	Alias of `log`. Computes the base-10 logarithm of `x`.
`log2(x)`	Computes the base-2 log of `x`.
`multiply(x, y)`	Alias for `x * y`.
`nextafter(x, y)`	Return the next floating point value after `x` in the direction of `y`.
`pi()`	Returns the value of pi.
`pow(x, y)`	Computes `x` to the power of `y`.
`power(x, y)`	Alias of `pow`. Computes `x` to the power of `y`.
`radians(x)`	Converts degrees to radians.
`random()`	Returns a random number `x` in the range `0.0 <= x < 1.0`.
`round_even(v NUMERIC, s INTEGER)`	Alias of `roundbankers(v, s)`. Round to `s` decimal places using the rounding half to even rule. Values `s < 0` are allowed.
`round(v NUMERIC, s INTEGER)`	Round to `s` decimal places. Values `s < 0` are allowed.
`setseed(x)`	Sets the seed to be used for the random function.
`sign(x)`	Returns the sign of `x` as -1, 0 or 1.
`signbit(x)`	Returns whether the signbit is set or not.
`sin(x)`	Computes the sin of `x`.
`sqrt(x)`	Returns the square root of the number.
`subtract(x, y)`	Alias for `x - y`.
`tan(x)`	Computes the tangent of `x`.
`trunc(x)`	Truncates the number.
`xor(x, y)`	Bitwise XOR.

Description	Absolute value. Parentheses are optional if `x` is a column name.
Example	`@(-17.4)`
Result	`17.4`
Alias	`abs`

Description	Absolute value.
Example	`abs(-17.4)`
Result	`17.4`
Alias	`@`

Description	Computes the inverse cosine of `x`.
Example	`acos(0.5)`
Result	`1.0471975511965976`

Description	Computes the inverse hyperbolix sine of `x`.
Example	`asinh(0.5)`
Result	`0.48121182505960347`

Description	Computes the inverse tangent (y, x).
Example	`atan2(0.5, 0.5)`
Result	`0.7853981633974483`

Description	Computes the base-10 log of `x`.
Example	`log(100)`
Result	`2`

About this page

In this article