Help Center/ SecMaster/ User Guide/ Threat Operations/ Security Analysis/ Query and Analysis Statements - SQL Syntax/ Limitations and Constraints

Updated on 2024-11-06 GMT+08:00

View PDF

Limitations and Constraints

Query statements do not support mathematical operations, such as (age + 100) ≤ 1000.
Aggregate functions support only fields and do not support expressions, for example, avg(log(age)).
Multi-table association is not supported.
Subqueries are not supported.
A maximum of 500 records can be returned on the page.
A maximum of 10,000 groups can be returned by GROUP BY.

Parent topic: Query and Analysis Statements - SQL Syntax

Previous topic: Basic Syntax

Next topic: Query Statements

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel