SubQuery Equivalent

Hi Team,

Looking to implement a SQL SubQuery in Druid, could you help me with the following equivalent in Druid SQL.

SQL - select * from table A where id = ( select max(id) from table A groupby id )

Thanks and Regards,

Akshay Rajakanthan

Won’t ordering by id desc and limiting results to 1 work?