Sorting and limiting
Use the MQL ORDER BY
clause to sort the output by one of the table columns, and use the LIMIT
clause to limit the number of rows retrieved, together with the OFFSET
clause to page through the data set. For LIMIT
, the default limit is 1000 and you cannot increase the limit.
The ORDER BY
and LIMIT
clauses are available to list, aggregation, and distribution queries.
Here are some examples.
Response date in descending order, and only show the first ten responses
select fullname, responsedate, br_overall_experience, br_likely_to_recommend, br_likely_to_buy_next_prod, comments from survey where has_comment=1 order by responsedate desc limit 10
Response date in descending order, and only show the second ten responses
select fullname, responsedate, br_overall_experience, br_likely_to_recommend, br_likely_to_buy_next_prod, comments from survey where has_comment=1 order by responsedate desc limit 10 offset 10
Year column in the response date column
select responsedate.year, distribution_value, dist(br_overall_experience), dist(br_likely_to_recommend), dist(br_likely_to_buy_next_prod) from survey order by responsedate.year
Response date in descending order, and show only the first thirty results
SELECT fullname, responsedate, br_overall_experience, br_likely_to_recommend, comments, alert_type, alert_status FROM SURVEY ORDER BY responsedate DESC LIMIT 30
Average value of br_overal_interaction in descending order
SELECT unitid.name, count(*), avg(br_overal_interaction), avg(br_overall_experience), avg(br_likely_to_recommend), avg(br_likely_to_buy_next_prod) FROM SURVEY ORDER BY avg(br_overal_interaction) DESC