CREATE TABLE act_ru_task
(
   id_                 varchar(64)     NOT NULL,
   rev_                integer,
   execution_id_       varchar(64),
   proc_inst_id_       varchar(64),
   proc_def_id_        varchar(64),
   case_execution_id_  varchar(64),
   case_inst_id_       varchar(64),
   case_def_id_        varchar(64),
   name_               varchar(255),
   parent_task_id_     varchar(64),
   description_        varchar(4000),
   task_def_key_       varchar(255),
   owner_              varchar(255),
   assignee_           varchar(255),
   delegation_         varchar(64),
   priority_           integer,
   create_time_        timestamp,
   due_date_           timestamp,
   follow_up_date_     timestamp,
   suspension_state_   integer,
   tenant_id_          varchar(64)
);

SELECT task.*
FROM act_ru_task task
GROUP BY task.id_,         task.due_date_
ORDER BY task.due_date_ ASC LIMIT 10 OFFSET 0;