By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE db (
"Date" datetime2,
"Count" INTEGER,
"id" VARCHAR(20),
"Approver" VARCHAR(20)
);
set dateformat ymd;
INSERT INTO db
("Date", "Count", "id", "Approver")
VALUES
('2022-04-13 14:49:15.0000000', '1', 'E3', 'Sourav'),
('2020-04-13 17:49:15.0000000', '1', 'E3', 'Soumyajit'),
('2019-05-15 19:49:15.0000000', '1', 'E3', 'Raju');
3 rows affected
SELECT *,
SUM(Count) OVER (PARTITION BY Id) AS TCount,
MAX(Date) OVER (PARTITION BY Id) AS LDate,
FIRST_VALUE(Approver) OVER
(PARTITION BY Id ORDER BY Date DESC ROWS UNBOUNDED PRECEDING) AS LApprover
FROM db;
| Date | Count | id | Approver | TCount | LDate | LApprover |
|---|---|---|---|---|---|---|
| 2022-04-13 14:49:15.0000000 | 1 | E3 | Sourav | 3 | 2022-04-13 14:49:15.0000000 | Sourav |
| 2020-04-13 17:49:15.0000000 | 1 | E3 | Soumyajit | 3 | 2022-04-13 14:49:15.0000000 | Sourav |
| 2019-05-15 19:49:15.0000000 | 1 | E3 | Raju | 3 | 2022-04-13 14:49:15.0000000 | Sourav |