按登录时间分组。您可能还需要在select子句中登录小时。

Group by the hour of the log in. You may also want the hour of the log in in the select clause.

@ddtpmyra ，这些是你要找的结果吗？

@ddtpmyra, are these the results that you are looking for?

Adezii，


是的我想计算每小时当前登录的数量。我想捕捉他们甚至早早登记，比如早上8点而不是退出，因为10点以后，我想算上午10点。并且他们有时间登录并注销，我无法配置查询如何执行此操作。

Adezii,

Yes I want to count how many currently login on each hour. I wanted to capture even they log at early times like 8am and not logout since after 10, I wanted to be counted on the 10am. And there are time they will be login and logging out, I can''t configure a query how to do this.