Database.Guide

Skip to content

Beginners

  • What is a Database?
  • Database Tutorial

SQL

  • SQL Tutorial
  • SQL Reference
  • SQL Joins Tutorial
  • SQL Transactions Tutorial
  • Basic SQL Queries

Categories

  • Azure SQL Edge (17)
  • Database Concepts (99)
  • Database Tools (72)
  • DBMS (9)
  • DuckDB (141)
  • MariaDB (424)
  • Microsoft Access (17)
  • MongoDB (265)
  • MySQL (602)
  • NoSQL (8)
  • Oracle (301)
  • PostgreSQL (480)
  • Redis (210)
  • SQL (697)
  • SQL Server (1,169)
  • SQLite (298)

Category: DBMS

Database Management Systems

MongoDB $cmp

Posted on March 2, 2021March 2, 2021 by Ian

In MongoDB, the $cmp aggregation pipeline operator compares two values and returns either -1, 1, or 0, depending on whether the first value is less than, greater than, or equal to the first value.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $floor

Posted on March 1, 2021March 1, 2021 by Ian

In MongoDB, the $floor aggregation pipeline operator returns the largest integer less than or equal to the specified number.

$floor accepts any valid expression that resolves to a number.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $ceil

Posted on March 1, 2021March 1, 2021 by Ian

In MongoDB, the $ceil aggregation pipeline operator returns the smallest integer greater than or equal to the specified number.

$ceil accepts any valid expression that resolves to a number.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $sqrt

Posted on March 1, 2021March 1, 2021 by Ian

In MongoDB, the $sqrt aggregation pipeline operator calculates the square root of a positive number and returns the result as a double.

$sqrt accepts any valid expression that resolves to a non-negative number.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $tan

Posted on February 28, 2021February 28, 2021 by Ian

In MongoDB, the $tan aggregation pipeline operator returns the tangent of a value that is measured in radians.

$tan accepts any valid expression that resolves to a number.

The $tan operator was introduced in MongoDB 4.2.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $sinh

Posted on February 28, 2021February 28, 2021 by Ian

In MongoDB, the $sinh aggregation pipeline operator returns the hyperbolic sine of a value that is measured in radians.

$sinh accepts any valid expression that resolves to a number.

The $sinh operator was introduced in MongoDB 4.2.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $sin

Posted on February 28, 2021February 28, 2021 by Ian

In MongoDB, the $sin aggregation pipeline operator returns the sine of a value that is measured in radians.

$sin accepts any valid expression that resolves to a number.

The $sin operator was introduced in MongoDB 4.2.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $pow

Posted on February 27, 2021February 27, 2021 by Ian

In MongoDB, the $pow aggregation pipeline operator raises a number to the specified exponent and returns the result

$pow accepts two expressions, supplied in an array. The first one is the number, and the second is the exponent. Both can be any valid expression, as long as they resolve to a number.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $log10

Posted on February 27, 2021February 27, 2021 by Ian

In MongoDB, the $log10 aggregation pipeline operator calculates the log base 10 of a number and returns the result as a double.

$log10 accepts any valid expression that resolves to a non-negative number.

The $log10 operator was introduced in MongoDB 3.2.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $atanh

Posted on February 27, 2021 by Ian

In MongoDB, the $atanh aggregation pipeline operator returns the hyperbolic arctangent (inverse hyperbolic tangent) of a value.

The return value is in radians.

$atanh accepts any valid expression that resolves to a number between -1 and 1.

The $atanh operator was introduced in MongoDB 4.2.

Continue reading →
MongoDB aggregation, operators, what is
  • «
  • 1
  • …
  • 225
  • 226
  • 227
  • 228
  • 229
  • …
  • 368
  • »

About Database.Guide | Privacy Policy