Aug 13, 2015 05:27 PM|avt2k7|LINK
I have a Oracle query similar syntax as following
FROM tblAccount INNER JOIN tblTransaction ON tblAccount.ACCOUNT_NUMBER = tblTransaction.ACCOUNT_NUMBER
INNER JOIN tblDate ON tblDate.TRANSACTION_DATE = tblAccount.TRANSACTION_DATE
WHERE TRUNC(tblDate.TRANSACTION_DATE) >= '1-APR-15' AND TRUNC(tblDate.TRANSACTION_DATE) <= '30-APR-15'
ORDER BY tblDate.TRANSACTION_DATE;
My query result returns some of duplicated records by account number, amount, type and transaction date. I really appreciate if anyone can modify above query to produce the result without any duplicated rows.
My above query result is displayed the duplicated records as following:
ACCOUNT_NUMBER | AMOUNT | TYPE | TRANSACTION_DATEA1, 100, credit, 04/01/2015B2, 35, credit, 04/04/2015C3, 690, debit, 04/20/2015...A1, 100, credit, 04/01/2015B2, 35, credit, 04/04/2015....Thanks in advance.