Magento Business Intelligence Help Center

What SQL functions are supported?


Any SELECT function, or any function that doesn't mutate data, that's supported by PostgreSQL is supported in the SQL Report Builder. This includes, but isn’t limited to AVG, COUNT, COUNT DISTINCT, MIN/MAX, and SUM.

In addition, any JOIN type is supported but we recommend only using INNER JOIN as it's the least expensive of the JOIN types.

<< Back to the SQL Report Builder FAQ list

Was this article helpful?
0 out of 0 found this helpful


Powered by Zendesk