GROUP BY IN ADHOC

[phaks]

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

[ghudson_1]

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)