Yandex Cloud
Documentation
PresentationContact UsTry it for free
© 2026 Direct Cursus Technology L.L.C.
Yandex DataLens
    • Overview
    • Formula syntax
    • Neuroanalyst for creating calculated fields
      • All Functions
        • Overview
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEILING
        • COMPARE
        • COS
        • COT
        • DEGREES
        • DIV
        • DIV_SAFE
        • EXP
        • FDIV_SAFE
        • FLOOR
        • GREATEST
        • LEAST
        • LN
        • LOG
        • LOG10
        • PI
        • POWER
        • RADIANS
        • ROUND
        • SIGN
        • SIN
        • SQRT
        • SQUARE
        • TAN
      • Function Availability
    • Parameters
  • DataLens Gallery
  • Audit Trails events
  1. Calculated fields
  2. Function reference
  3. Mathematical functions
  4. LEAST

LEAST

Written by
Yandex Cloud
Improved by
amatol
Updated at December 19, 2025
View in Markdown

SyntaxSyntax

LEAST( value_1, value_2, value_3 [ , ... ] )

DescriptionDescription

Returns the smallest value.

See also GREATEST.

Depending on the specified data type, it returns:

  • The smallest number.
  • The first string in alphabetical order.
  • The earliest date.
  • FALSE when selecting between TRUE and FALSE for Boolean type.

Argument types:

  • value_1 — Boolean | Date | Datetime | Fractional number | Integer | String
  • value_2 — Boolean | Date | Datetime | Fractional number | Integer | String
  • value_3 — Boolean | Date | Datetime | Fractional number | Integer | String

Return type: Same type as (value_1, value_2, value_3)

Note

Arguments (value_1, value_2, value_3) must be of the same type.

ExamplesExamples

LEAST(3.4, 2.6) = 2.6
LEAST("3.4", "2.6") = "2.6"
LEAST(#2019-01-02#, #2019-01-17#) = #2019-01-02#
LEAST(#2019-01-02 04:03:02#, #2019-01-17 03:02:01#) = #2019-01-02 04:03:02#
LEAST(TRUE, FALSE) = FALSE
LEAST(34, 5, 7, 3, 99, 1, 2, 2, 56) = 1
LEAST(5.6, 1.2, 7.8, 3.4) = 1.2
LEAST(#2019-01-02#, #2019-01-17#, #2019-01-10#) = #2019-01-02#

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Microsoft SQL Server 2017 (14.0), MySQL 5.7, Oracle Database 12c (12.1), PostgreSQL 9.3, Trino, Yandex Documents, YDB.

Was the article helpful?

Previous
GREATEST
Next
LN
© 2026 Direct Cursus Technology L.L.C.