ClickHouse 获取分组后的最新一条数据

原始数据

需要获取 查询取每个分组后的第一条记录

Sql 代码如下

select user_id, 
       school_id, 
       device_sn,
       gmt_create
  from app_device_info
  WHERE gmt_create >='2023-11-24 00:00:00' and gmt_create <='2023-11-25 00:00:00'  
  and user_id in('34060220091028164X','340602201007092249','340621201212263683')
  ORDER by user_id,gmt_create DESC
  LIMIT   1 BY user_id