> (Greater Than) (U-SQL)

Article
03/27/2017

Summary

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

Syntax

Greater_Than_Operator :=                                                                                 
    expression '>' expression.

Remarks

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 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 greater than 8,000.
@result = SELECT * FROM @somePeople WHERE Salary > 8000;
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/greaterThan1.txt" USING Outputters.Tsv();

// All records where StartDate is after 12/31/2014
@result = SELECT * FROM @somePeople WHERE StartDate > new DateTime(2014,12,31);
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/greaterThan2.txt" USING Outputters.Tsv();

Share via