Skip to content

Public
Authored by Teddy Darmadi 💬

SQL: Branch list untuk MFI

Note ini hanya menampilkan tanggal transaksi pertamanya saja

Edited
mfi_branch_list.sql 267 Bytes
  • Teddy Darmadi 💬 @clixie ·

    Untuk dapetin max salesnya, terpaksa pake query ini:

    SELECT 
  isa.br_id, MAX(isa.is_date)
FROM item_sale isa
GROUP BY isa.br_id

    Lalu pindahin ke excel manual

    Edited by Teddy Darmadi
Markdown is supported
0% or
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment