< (Less Than) (U-SQL)
Updated: March 27, 2017
Compares two expressions (a comparison operator). When you compare nonnull expressions, the result is TRUE if the left operand has a value lower than the right operand; otherwise, the result is FALSE.
| Syntax |
|---|
Less_Than_Operator :=
expression '<' expression.
|
Semantics of Syntax Elements
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.
Less 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 less than 15,000.
@result = SELECT * FROM @somePeople WHERE Salary < 15000;
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/lessThan1.txt" USING Outputters.Tsv();
// All records where StartDate is before 01/01/2015
@result = SELECT * FROM @somePeople WHERE StartDate < new DateTime(2015,01,01);
OUTPUT @result TO "/ReferenceGuide/Operators/Comparison/lessThan2.txt" USING Outputters.Tsv();
See Also
Community Additions
ADD
Show: