5 Find all the vendors who have invoices with termsduedate b

5 Find all the vendors who have invoices with terms_due_date between 20 and 60 days. oracle sql query

Solution

Find all the vendors who have invoices with terms_due_date between 20 and 60 days. oracle sql query

You have not posted all details of Schema.
But based on your question i have prepared a quey(idea).
You have to use correct table name and columns name.

You have to use BETWEEN and AND clause in this query

select *
from vendors_table
where terms_due_date BETWEEN 20 AND 60