Sometimes it's worked out; the company gives them a big raise, a lump sum in the key of "Sorry!" and the person remains a happy and productive -- and wiser -- member of the team.
Usually they're gone within months, though. And often other people follow ("You got /how/ much at OtherCorp?").