Help Center/ SecMaster/ User Guide/ Threat Operations/ Query and Analysis Syntax - V2/ SecMaster SQL Syntax Reference/ Data Query Language (DQL) Syntax/ OrderBy & Limit
Updated on 2024-12-20 GMT+08:00
View PDF
Share

OrderBy & Limit

OrderBy

  • Function

    This clause is used to sort data in ascending order on a time attribute.

  • Precautions

    Currently, only sorting by time attribute is supported.

  • Example

    Sort data in ascending order on the time attribute.

    SELECT *
FROM Orders
ORDER BY orderTime;

Limit

  • Function

    This clause is used to constrain the number of rows returned.

  • Precautions

    This clause is used in conjunction with ORDER BY to ensure that the results are deterministic.

  • Example 
    SELECT *
FROM Orders
ORDER BY orderTime
LIMIT 3;