I have to create one BO report. There is one Excel file, with Type, type_ID,(each type has many different type_ids), eg
-
type type_id
IHEI IHEI121
IHEI IHEI132
IHEI IHEI212
IHDI IHDI511
IHDI IHDI232
IDWU IDWU212
IDWU ...............
.....
now I want to count the occurrences of these type_ids in the oracle database.
This should be relatively easy, with
select type, type_id, count(type_id)
from my_table
where type in ('IHEI', ...)
however, since the there are many more data in the database than in the Excel file, it will also count those type_ids that are not in the Excel file
So, how to get rid of those type_ids and keep only those coming from the Excel file?
thanks for your help!