Limit doesnot work with Group by for Influx v2, influxQL

[kondubhSICKAG]

Hi I am trying to implement Pagination while performing group by tags with influx v2 and java client.
I am performing limit query with group by tag I see that the pagination/limit does not work, Is there a way to apply limit ?
SELECT count("InspectionStatus") AS "count-InspectionStatus",count("System ID") AS "count-System ID",count("Link ID") AS "count-Link ID",count("Chain system id") AS "count-Chain system id",count("Loop Number") AS "count-Loop Number",count("leftcamerastatus") AS "count-leftcamerastatus",count("rightcamerastatus") AS "count-rightcamerastatus",count("Right camera") AS "count-Right camera",count("Left Camera") AS "count-Left Camera" FROM "CC3B" WHERE time >= '2024-03-01T05:00:00.000Z' AND time <= '2024-03-01T21:12:06.334Z' GROUP BY subtype,time(1d) ORDER BY time DESC LIMIT 100;