ECNO BRANCH MONTH ISDELETED 1 B1 February 2018 n 2 B3 February 2018 n 3 B3 March 2018 n 4 B1 March 2018 n 5 B2 January 2018 n 6 B3 January 2018 n
select * from HR_BULKBILL_DETAILS where BRANCH='B3' AND MONTH='March 2018'
select * from HR_BULKBILL_DETAILS where MONTH='February 2018' AND MONTH='March 2018' AND BRANCH='B3'
Finally I got result by using "between" Following is the query: select * from HR_BULKBILL_DETAILS where MONTH Between 'February 2018' AND 'March 2018' and BRANCH='B3'
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)