You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
-- 2.9sSELECT ClientIP, ClientIP -1, ClientIP -2, ClientIP -3, COUNT(*) AS c FROM hits GROUP BY ClientIP, ClientIP -1, ClientIP -2, ClientIP -3ORDER BY c DESCLIMIT10;
Here ClientIP is INT. This query can be rewritten in the following form:
-- 2.1sSELECT ClientIP, ClientIP -1, ClientIP -2, ClientIP -3, COUNT
FROM (SELECT ClientIP, COUNT(*) AS c FROM hits GROUP BY ClientIP ORDER BY c DESCLIMIT10);
Apart from subtraction, we could support adding, multiplication and division.
Describe the solution you'd like.
No response
Describe alternatives you've considered.
No response
Full Name:
Andrei Pechkurov
Affiliation:
QuestDB
Additional context
No response
The text was updated successfully, but these errors were encountered:
Is your feature request related to a problem?
Example query:
Here ClientIP is INT. This query can be rewritten in the following form:
Apart from subtraction, we could support adding, multiplication and division.
Describe the solution you'd like.
No response
Describe alternatives you've considered.
No response
Full Name:
Andrei Pechkurov
Affiliation:
QuestDB
Additional context
No response
The text was updated successfully, but these errors were encountered: