How to fetch specified data based on two columns in PostgreSQL

Question

I am new to writing queries in SQL, and struggling to get the datas from table.

I have a table called "address" in DB. Here, I have more columns and specifically from two column I need to get the datas filtered out. Both are integers

frequency_type_id
date_of_invoice_id

I need to get rows only where frequency_type_id = 1 and date_of_invoice_id=2, and frequency_type_id = 2 and date_of_invoice_id=3, frequency_type_id = 3 and date_of_invoice_id=1.

I am trying with the following query, but its not filtering properly,

SELECT address_id, company_name,  
invoice_batch_billing, frequency_type_id,  date_of_invoice_id
FROM pls.address where invoice_style='Consolidated' 
and frequency_type_id in 
(SELECT frequency_type_id from  pls.address where frequency_type_id=1 and date_of_invoice_id=1);

Hope someone assist.

Fahmi · Accepted Answer · 2018-08-08 09:39:10Z

1

Try below query:

SELECT address_id, company_name,  
invoice_batch_billing, frequency_type_id,  date_of_invoice_id
FROM pls.address where invoice_style='Consolidated' 
and ((frequency_type_id=1 and date_of_invoice_id=2) or (frequency_type_id=2 and date_of_invoice_id=2) or (frequency_type_id=3 and date_of_invoice_id=2))

answered Aug 8, 2018 at 9:39

Fahmi

37.5k5 gold badges26 silver badges32 bronze badges

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

Comments

Rahul Jain · Accepted Answer · 2018-08-08 09:39:41Z

0

Try this:

SELECT 
    address_id, 
    company_name,
    invoice_batch_billing,
    frequency_type_id,
    date_of_invoice_id
FROM 
    pls.address
WHERE
    frequency_type_id IN (1,2,3) 
AND 
    date_of_invoice_id=2

If I have understand your question correctly, this will suffice your requirement.

answered Aug 8, 2018 at 9:39

Rahul Jain

1,3997 silver badges16 bronze badges

1 Comment

J Query Over a year ago

Thanks Rahul. This is fine for same date_of_invoice_id. If there is change in the value of date_of_invoice_id like 1 for frequency_type_id. This works?

Collectives™ on Stack Overflow

How to fetch specified data based on two columns in PostgreSQL

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related