By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE approval(m_requisition_id numeric(10),ad_wf_activity_id numeric(10),bpname VARCHAR(100), designation VARCHAR(100));
INSERT INTO approval VALUES
(1014546,1014546,'Abul Kalam Azad','Asst. Manager'),
(1014546, 1225097,'Md. Hasan Zahir','Plant Manager'),
(1014546,1229239,'Md. Hasan Zahir','Plant Manager'),
(1014546,1229240,'Sayela Alam','Sr. Manager'),
(1014546,1229241,'Md. Hasan Zahir','Plant Manager'),
(1014546,1229242,'Sayela Alam','Sr. Manager');
Select * from approval;
select m_requisition_id, max(ad_wf_activity_id), bpname, designation
from approval
GROUP BY m_requisition_id, bpname, designation
6 rows affected
| m_requisition_id | ad_wf_activity_id | bpname | designation |
|---|---|---|---|
| 1014546 | 1014546 | Abul Kalam Azad | Asst. Manager |
| 1014546 | 1225097 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229239 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229240 | Sayela Alam | Sr. Manager |
| 1014546 | 1229241 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229242 | Sayela Alam | Sr. Manager |
| m_requisition_id | max | bpname | designation |
|---|---|---|---|
| 1014546 | 1014546 | Abul Kalam Azad | Asst. Manager |
| 1014546 | 1229241 | Md. Hasan Zahir | Plant Manager |
| 1014546 | 1229242 | Sayela Alam | Sr. Manager |