Table of contents
TOC
Collapse the table of content
Expand the table of content

>= (Greater Than or Equal To) (U-SQL)

Michael Rys|Last Updated: 5/15/2018
|
4 Contributors

Compares two expressions for greater than or equal (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand has a greater or equal value than the right operand; otherwise, the result is FALSE.

Syntax
Greater_Than_Or_Equal_To_Operator :=                                                                     
    expression '>=' expression.

Semantics of Syntax Elements

  • expression
    Is any valid expression. Both expressions must have implicitly convertible data types.

Return Type

Boolean.

Examples

  • The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
  • The scripts can be executed locally. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.

Greater Than or Equal To with Numeric and Temporal Types

@somePeople = 
    SELECT * FROM 
        ( VALUES
        (1, "Noah",    100, (int?)10000, new DateTime(2012,05,31)),
        (2, "Sophia",  100, (int?)15000, new DateTime(2012,03,19)),
        (3, "Liam",    100, (int?)30000, new DateTime(2014,09,14)),
        (6, "Emma",    200, (int?)8000,  new DateTime(2014,03,08)),
        (7, "Jacob",   200, (int?)8000,  new DateTime(2014,09,02)),
        (8, "Olivia",  200, (int?)8000,  new DateTime(2013,12,11)),
        (9, "Mason",   300, (int?)50000, new DateTime(2016,01,01)),
        (10, "",       400, (int?)15000, new DateTime(2014,09,14)),
        (11, "Ethan ", 400, (int?)null,  new DateTime(2015,08,22))
        ) AS T(EmpID, EmpName, DeptID, Salary, StartDate);

// All records where Salary is 8,000 or greater.
@result = SELECT * FROM @somePeople WHERE Salary >= 8000;
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/greaterThanOrEqualTo1.txt" USING Outputters.Tsv();

// All records where StartDate is 03/08/2014 or later
@result = SELECT * FROM @somePeople WHERE StartDate >= new DateTime(2014,03,08);
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/greaterThanOrEqualTo2.txt" USING Outputters.Tsv();

See Also

© 2018 Microsoft