Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- PA.ID,
- PA.AREA,
- PA.CITY,
- PA.STREET,
- PA.HOUSE,
- PA.APARTAMENT,
- PA.CODE_ACCOUNT,
- -- OBF.ADRESS_FIAS,
- -- OBF.KADASTR_NUMBER,
- -- OBF.FIAS,
- PA.FIO,
- PA.CONTRACT_NAME,
- PA.HOUSE_TYPE,
- PA.DATE_FROM,
- PA.DATE_BY,
- PA.DATE_CREATE,
- PA.DATE_UPDATE,
- PA.USER_ID,
- PA.CONTRACT_ID,
- PA.RKC,
- B1.SALDO_K,
- B1.KOL_MONTH,
- B1.PAYMENT,
- B1.RECALC,
- B1.ACCRUAL,
- TO_CHAR(B1.BALANCE_DATE, 'yyyy-mm-dd') AS BALANCE_DATE
- FROM
- PERSONAL_ACCOUNT PA
- LEFT JOIN (
- SELECT
- B.ACCOUNT_ID,
- B.BALANCE_DATE,
- B.SALDO_N,
- B.ACCRUAL,
- B.RECALC,
- B.PAYMENT,
- CASE WHEN B.ACCRUAL <> 0 THEN ROUND(B.SALDO_N / B.ACCRUAL, 0) ELSE 0 END KOL_MONTH,
- B.SALDO_K
- FROM
- BALANCE B
- JOIN (
- SELECT
- ACCOUNT_ID,
- MAX(BALANCE_DATE) AS MAX_BALANCE_DATE
- FROM
- BALANCE
- GROUP BY
- ACCOUNT_ID
- ) MAX_BALANCE_DATE ON B.ACCOUNT_ID = MAX_BALANCE_DATE.ACCOUNT_ID
- AND B.BALANCE_DATE = MAX_BALANCE_DATE.MAX_BALANCE_DATE
- ) B1 ON PA.ID = B1.ACCOUNT_ID
- LIMIT 5
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement