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. COMPARE

COMPARE

Written by
Yandex Cloud
Updated at November 6, 2024
View in Markdown

SyntaxSyntax

COMPARE( left, right, epsilon )

DescriptionDescription

Returns:

  • 0 if left and right differs by not more than epsilon.
  • -1 if left is less than right by more than epsilon.
  • 1 if left is greater than right by more than epsilon.

Argument types:

  • left — Fractional number | Integer
  • right — Fractional number | Integer
  • epsilon — Fractional number | Integer

Return type: Integer

ExamplesExamples

COMPARE(1.25, 1.26, 0.1) = 0
COMPARE(1.25, 1.26, 0.001) = -1
COMPARE(1.26, 1.25, 0.001) = 1

Data source supportData source support

ClickHouse 21.8, Files, Google Sheets, Yandex Documents.

Was the article helpful?

Previous
CEILING
Next
COS
© 2026 Direct Cursus Technology L.L.C.