[feature request] ORDER BY function return values.

[gam-phon]

This is the same request as #3954 but this feature request to be ordered by count.
Example:

select count(values) from events group by event_type order by count desc

[mvadu]

+1 Allowing this with limit clause will allow for lot of interesting queries on the time series. It can be a dirty fix for #5345 for Top as well.

Something like below should give the worst performing transaction for an hour.
SELECT percentile(ResponseTime,90) FROM "Application_Transaction_Metrics" WHERE "State" =~ /California$/ AND time > 1452623400s and time < now() GROUP BY time(1h), "State", BusinessTransaction Order By percentile desc limit 1

[max3163]

+1

This function is rly a most have !

[ghost]

+1

[ericx10ng]

+1

[cmdrSpectral]

+1

[mebrunet]

+1 This would be really useful!

[seb-koch]

+1, definitely a must

[consense]

is there any update on the roadmap position for this?

[bfgoodrich]

It is now 2018, any update on this at all?

[NateZimmer]

Generally one wishes to target problematic devices. One can't target the most problematic devices if one cannot sort a long list by those values... this is kinda an embarrassing feature not to have.

[nathanielc]

Added difficulty/high as arbitrary sorting on the results is not possible nor is there a current easy place to hook in such behavior in InfluxQL. Flux is already capable of sorting the results by an arbitrary value.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.

[stale]

This issue has been automatically closed because it has not had recent activity. Please reopen if this issue is still important to you. Thank you for your contributions.

[CanuckMarc]

2021 and still can't order by anything other than time.

[rsoudani]

same in late 2022, sad