Taking some clues from your comment (below the question):
Actually the leave is submitted with start and end date. And the leave
period can be span on several months (like the highlighted case in
picture) so i want to calculate specific month leave that how many
leaves are occur in specific month from total leave
So basically, if both the "input start date" values are less than both the
less_end_date values, that means the leave does not fall in the input range. Similarly, if the "input end date" value is greater than both of them, then also, the leave does not fall in the input range. So, we can use this "negative" condition, to consider cases where leave falls in the range:
(leave_start_date < '2019-09-01' AND leave_end_date < '2019-09-01')
(leave_start_date > '2019-09-31' AND leave_end_date > '2019-09-31')
Here is a similar answer of mine on StackOverflow giving further explanation: https://stackoverflow.com/a/53319378/2469308
Now, if it is ensured that
leave_end_date will always be
>= to the
leave_start_date (data sanity is ensured), then we can condense the query further (thanks to suggestion by @Akina):
leave_end_date < '2019-09-01'
leave_start_date > '2019-09-31'