filtering specific column value by date in postgresql

Question

I am trying to write a SQL query which will only filter specific column value by specific date range.In other cases it will not consider the data range.

This is my SQL query:

select ld.level_data as name,sum(dm.revenue) as value
from deal_management dm
left join lookup_data ld on ld.id = dm.pipeline_id
left join lookup_data ld1 on ld1.id=ld.parent_id
group by ld.level_data

This is the result I am getting:

name        value
-----------------
Win         190
Nurturing   200
Lost        210

What I want is only when value is Win I want to filter by date and in case of other value it will not consider the date range.Something like this:

where ld.level_data = 'Win' 
  and cast((dm.created_date) as date) between '2021-01-01' and '2021-01-31'

How can I do it by maintaining the same structure?

Popeye · Accepted Answer · 2021-02-01 07:06:53Z

2

You can use boolean conditions in WHERE as follows:

WHERE (ld.level_data != 'Win' 
       OR cast((dm.created_date)as date)between '2021-01-01' and '2021-01-31' 
      )

answered Feb 1, 2021 at 7:06

Popeye

36k4 gold badges12 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

filtering specific column value by date in postgresql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related