GROUP BY IN ADHOC

0

How can i do group SQL group by in adhoc? e.g select * from transactions group by transcode;

phaks's picture
7
Joined: Mar 10 2014 - 8:13am
Last seen: 3 years 3 months ago

1 Answer:

0

As superuser, go to manager -> server settings -> Adhoc settings and checkmark enable view query.  This allows you to see the query being generated at runtime.   When you create an adhoc from topic or domain, if you drag a field into the "group" the server will actually peform that grouping in memory.   If you want the group by clause to be added to the query then if using a topic, you need to ensure your topic contains this group by in the queryString for the topic, or if using a domain, then ensure that your domain enforces this clause (via derived table or other means)

ghudson_1's picture
28120
Joined: Oct 30 2012 - 12:51pm
Last seen: 18 hours 47 min ago
Feedback
randomness