Advertisement
JoeKidoyagami

QUERYKU

Jun 18th, 2019
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. SELECT T1.Nama,
  2. T1.besar_angsuran,
  3. T1.tgl_angsur,
  4. T1.jatuh_tempo,
  5. CASE
  6. WHEN T1.tgl_angsur > T2.jatuh_tempo THEN 'TELAT'
  7. ELSE 'TIDAK'
  8. END
  9. FROM
  10. (
  11. SELECT * ,
  12. @row_num :=IF(@prev_value = concat_ws('',Nama),@row_num+1,1)AS RowNumber
  13. , @prev_value := concat_ws('',Nama) AS Temp
  14. FROM trackku A,
  15. (SELECT @row_num := 0) r
  16. ORDER BY Nama,tgl_angsur
  17. )T1
  18. LEFT JOIN
  19. (
  20. SELECT * ,
  21. @row_num2 :=IF(@prev_value2 = concat_ws('',Nama),@row_num2+1,1)AS RowNumber2
  22. , @prev_value2 := concat_ws('',Nama) AS Temp
  23. FROM trackku B,
  24. (SELECT @row_num2 := 0) r
  25. ORDER BY Nama,tgl_angsur
  26. )T2 ON T1.Nama = T2.Nama
  27. AND T1.RowNumber = T2.RowNumber2 + 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement