When I am trying to exute the below query I am not getting any data even though I have currnt year and month data avaliable in the table.
Table is like as followes:
TNUMBER DOT TXNTYPE CHQNUM CHQDATE TXNAMT ACID BRID USERID
TNUMBER: TRANSACTION NUMBER, DOT: DATE OF TRANSACTION , TXNTYPE:TRANSACTION TYPE, CHQNUM:- CHEQUE NUMBER,
CHQDATE: CHEQUE DATE, TXNAMT: TRANSACTION AMOUNT, ACID: ACCOUNT ID, BRID: BRANCH ID, USERID: USER ID( BANK EMPLOYEE NUMBER)
===============================GET THE DATA OF CURRENT MONTH=========================================
SELECT ACID,
DOT,
TXNTYPE,
&nbs ...
Go to the complete details ...