We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Thank you for the great tool!
I'd like to request feature which works like COUNT(DISTINCT col1) ... GROUP BY of SQL. I tried count_agg(distinct col1), but got syntax error.
COUNT(DISTINCT col1) ... GROUP BY
count_agg(distinct col1)
The text was updated successfully, but these errors were encountered:
Hi, thank you :-)
The syntax is a little different in SPyQL. Please try:
SELECT count_distinct_agg(col1) ...
You can check the reference for more aggregation functions: https://spyql.readthedocs.io/en/latest/reference.html#module-spyql.agg
Please let me know if you were able to do what you needed. Thanks!
Sorry, something went wrong.
Ok, I'll try. Thank you!
Worked like a charm! Thank you!
No branches or pull requests
Thank you for the great tool!
I'd like to request feature which works like
COUNT(DISTINCT col1) ... GROUP BY
of SQL.I tried
count_agg(distinct col1)
, but got syntax error.The text was updated successfully, but these errors were encountered: