May I ask how to sort within subgroups in group queries

[tom055]

version:3.2.3.0

example：select ts,data,device_id,device_tag_name from super_device_data where device_id=6 partition by device_tag_name limit 5 offset 0;

i want to order by ts in subgroup，How to query？

Looking forward to your reply，thank u

[YukiYlf]

你上面少了聚会函数，比如min ,max
不过我在3.3.2版本遇到的问题，是无法多个同时聚合运算

[tom055]

@YukiYlf 如果聚合了，如max,sum,min等等那么子group的结果就只有一条那肯定能排序，结果如果有多个子group，每个子group有多条记录，再对每个子group进行排序好像不行

…

------------------ 原始邮件 ------------------ 发件人: "taosdata/TDengine" ***@***.***>; 发送时间: 2024年9月4日(星期三) 下午4:01 ***@***.***>; ***@***.******@***.***>; 主题: Re: [taosdata/TDengine] May I ask how to sort within subgroups in group queries (Issue #27597) 你上面少了聚会函数，比如min ,max 不过我在3.3.2版本遇到的问题，是无法多个同时聚合运算 — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***>