• select empid from tablename where flag='yes' and processingdate='old date'