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: NoSQL

MongoDB $min Aggregation Pipeline Operator

Posted on March 20, 2021March 20, 2021 by Ian

In MongoDB, the $min aggregation pipeline operator returns the minimum value from an expression.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $sum Aggregation Pipeline Operator

Posted on March 20, 2021March 20, 2021 by Ian

In MongoDB, the $sum aggregation pipeline operator calculates and returns the sum of numeric values.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $avg Aggregation Pipeline Operator

Posted on March 20, 2021March 20, 2021 by Ian

In MongoDB, the $avg aggregation pipeline operator calculates and returns the average value of the specified numeric values.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $substrBytes

Posted on March 19, 2021March 19, 2021 by Ian

In MongoDB, the $substrBytes aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 encoded bytes indexes.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $substrCP

Posted on March 19, 2021March 19, 2021 by Ian

In MongoDB, the $substrCP aggregation pipeline operator returns the substring of a string, based on the specified UTF-8 code point indexes.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $strLenCP

Posted on March 18, 2021March 18, 2021 by Ian

MongoDB, the $strLenCP aggregation pipeline operator returns the number of UTF-8 code points in the specified string.

The $strLenCP operator is different to the $strLenBytes operator, which returns the number of bytes in the string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $strLenBytes

Posted on March 18, 2021March 18, 2021 by Ian

MongoDB, the $strLenBytes aggregation pipeline operator returns the number of UTF-8 encoded bytes in the specified string.

Each character in a string can contain contain a different number of bytes, depending on the character being used. The $strLenBytes operator can figure out how many bytes each character contains and return the correct result for the whole string.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $stdDevPop

Posted on March 17, 2021March 17, 2021 by Ian

In MongoDB, the $stdDevPop aggregation pipeline operator calculates the population standard deviation of its input values. 

The input values can be from a group of documents (i.e. documents that are grouped by the same key), or they can be multiple fields within a single document.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $stdDevSamp

Posted on March 17, 2021March 17, 2021 by Ian

In MongoDB, the $stdDevSamp aggregation pipeline operator calculates the sample standard deviation of the input values.

The input values can be from a group of documents (i.e. documents that are grouped by the same key), or they can be multiple fields within a single document.

Continue reading →
MongoDB aggregation, operators, what is

MongoDB $strcasecmp

Posted on March 17, 2021March 17, 2021 by Ian

In MongoDB, the $strcasecmp aggregation pipeline operator performs a case-insensitive comparison of two strings.

It returns either 1, 0, or -1, depending on whether or not the first string is greater than, equal to, or less than the second string.

Continue reading →
MongoDB aggregation, operators, what is
  • «
  • 1
  • …
  • 24
  • 25
  • 26
  • 27
  • 28
  • …
  • 49
  • »

About Database.Guide | Privacy Policy