This ultimately drove Sam to join Dean in his quest to find John, and while Jess never resurrected like other Supernatural characters, Sam did get vengeance on the demon that killed her.
Jessica Moore was Sam’s girlfriend at the start of Supernatural, although their love was ultimately never meant to be.
Jess was killed under Azazel’s orders, and to drive the dagger deeper the murderer ended up being a demon that was also the “friend” that introduced the two.