Query to get all unassigned Positions and delete them

Can any guide me is it possible to identify all Positions which are not assigned and delete them. As we identified more positions are created and most of them are not utilized.