Hi All,
select 1111 invoice_id, 123 vendor_id from dual
union all
select 2222 invoice_id, 123 vendor_id from dual
union all
select 3333 invoice_id, 123 vendor_id from dual
union all
select 4444 invoice_id, 100 vendor_id from dual
I have the data like below and need to check each invoice data if the vendor_id is the same and I will pass invoice_id as a parameter.
I need to get a count for this.
oracle version: 11 version