SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE loan (mainindex, brindx, YearMonth, EmpID, VarNo, Name, LastName, CodepayID, CodepaySH, Lval, Lint, Lrmn);
✓
INSERT INTO loan (mainindex, brindx, YearMonth, EmpID, VarNo, Name, LastName, CodepayID, CodepaySH, Lval, Lint, Lrmn) VALUES 
(90, 90, 202102, 12455110, '0', 'sardar', 'Q', 649, 'zigbo', 304110, 27640, 0),
(91, 91, 202102, 12455230, '0', 'MMy', 'AAL', 649, 'zigbo', 304110, 27647, 165875),
(92, 92, 202102, 12455304, '0', 'GhlB', 'jeremi', 649, 'zigbo', 304110, 27640, 0),
(1389, 1, 202103, 12450400, '0', 'Bass', 'harini', 649, 'zigbo', 405480, 67580, 337900),
(1390, 2, 202103, 12452059, '0', 'Merry', 'faraje', 649, 'zigbo', 608220, 101370, 506850),
(1391, 3, 202103, 12455230, '0', 'MMy', 'AAL', 649, 'zigbo', 304110, 27647, 138228),
(1867, 1, 202104, 12450400, '0', 'Bass', 'harini', 649, 'zigbo', 0, 67580, 270320),
(1868, 2, 202104, 12455230, '0', 'MMy', 'AAL', 649, 'zigbo', 0, 27647, 110581),
(1869, 3, 202104, 12452059, '0', 'Merry', 'faraje', 649, 'zigbo', 0, 101370, 405480),
(3183, 1, 202105, 12450400, '0', 'Bass', 'harini', 649, 'zigbo', 0, 67580, 270320),
(3184, 2, 202105, 12455230, '0', 'MMy', 'AAL', 649, 'zigbo', 0, 27647, 110581),
(3185, 3, 202105, 12452059, '0', 'Merry', 'faraje', 649, 'zigbo', 0, 101370, 405480),
(5181, 1, 202106, 12450400, '0', 'Bass', 'harini', 649, 'zigbo', 405485, 67580, 202740),
(5182, 2, 202106, 12450270, '0', 'Bass', 'SLY', 649, 'zigbo', 1155400, 128378, 1027022),
(5183, 3, 202106, 12455230, '0', 'MMy', 'AAL', 649, 'zigbo', 304110, 27647, 82934),
(5184, 4, 202106, 12455093, '0', 'Mnsu', 'Fakara', 649, 'zigbo', 1334160, 222360, 1111800),
(5185, 5, 202106, 12452059, '0', 'Merry', 'faraje', 649, 'zigbo', 608220, 101370, 304110);
✓
SELECT DISTINCT EmpID, CodepayID,
       FIRST_VALUE(Lval) OVER (PARTITION BY EmpID, CodepayID ORDER BY YearMonth) LVal1,
       FIRST_VALUE(Lval) OVER (PARTITION BY EmpID, CodepayID ORDER BY YearMonth DESC) LVal2,
       SUM(Lint) OVER (PARTITION BY EmpID, CodepayID) sum_Lint,
       FIRST_VALUE(Lrmn) OVER (PARTITION BY EmpID, CodepayID ORDER BY YearMonth) Lrmn1,
       FIRST_VALUE(Lrmn) OVER (PARTITION BY EmpID, CodepayID ORDER BY YearMonth DESC) Lrmn2
FROM loan   


EmpID
CodepayID
LVal1
LVal2
sum_Lint
Lrmn1
Lrmn2


12450270
649
1155400
1155400
128378
1027022
1027022

12450400
649
405480
405485
270320
337900
202740

12452059
649
608220
608220
405480
506850
304110

12455093
649
1334160
1334160
222360
1111800
1111800

12455110
649
304110
304110
27640
0
0

12455230
649
304110
304110
138235
165875
82934

12455304
649
304110
304110
27640
0
0

`EmpID`	`CodepayID`	`LVal1`	`LVal2`	`sum_Lint`	`Lrmn1`	`Lrmn2`
`12450270`	`649`	`1155400`	`1155400`	`128378`	`1027022`	`1027022`
`12450400`	`649`	`405480`	`405485`	`270320`	`337900`	`202740`
`12452059`	`649`	`608220`	`608220`	`405480`	`506850`	`304110`
`12455093`	`649`	`1334160`	`1334160`	`222360`	`1111800`	`1111800`
`12455110`	`649`	`304110`	`304110`	`27640`	`0`	`0`
`12455230`	`649`	`304110`	`304110`	`138235`	`165875`	`82934`
`12455304`	`649`	`304110`	`304110`	`27640`	`0`	`0`