What does has emplid mean? Is this means not null, then this should do the trick:
delete from tablename where not emplid is null;
What does has emplid mean? Is this means not null, then this should do the trick:
delete from tablename where not emplid is null;