Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT T1.Nama,
- T1.besar_angsuran,
- T1.tgl_angsur,
- T1.jatuh_tempo,
- CASE
- WHEN T1.tgl_angsur > T2.jatuh_tempo THEN 'TELAT'
- ELSE 'TIDAK'
- END
- FROM
- (
- SELECT * ,
- @row_num :=IF(@prev_value = concat_ws('',Nama),@row_num+1,1)AS RowNumber
- , @prev_value := concat_ws('',Nama) AS Temp
- FROM trackku A,
- (SELECT @row_num := 0) r
- ORDER BY Nama,tgl_angsur
- )T1
- LEFT JOIN
- (
- SELECT * ,
- @row_num2 :=IF(@prev_value2 = concat_ws('',Nama),@row_num2+1,1)AS RowNumber2
- , @prev_value2 := concat_ws('',Nama) AS Temp
- FROM trackku B,
- (SELECT @row_num2 := 0) r
- ORDER BY Nama,tgl_angsur
- )T2 ON T1.Nama = T2.Nama
- AND T1.RowNumber = T2.RowNumber2 + 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement