filter big file based upon on multipe criteria
Posted on 2016-11-04
I have to filter based upon four columns emplid,empl_rcd,effdate ,seq filter is like 1000 rows in xls.
i can just do select can't create any tables etc.
i am doing
select * from tab
or(emplid=1 and empl_rcd=2 and effdate='2016-01-01 and seq='1')
or(emplid=2 and empl_rcd=2 and effdate='2012-01-01 and seq='1')
and so on like 1000 times
I was wondering is there any easy or quick way to do it.