Characters getting killed and then being brought back to life is a common element in TV shows with a supernatural element, and several central figures die a few times in "The X-Files," "Buffy the Vampire Slayer," and "Supernatural." In these types of dramas, a main character's death is no guarantee that they will remain dead — no matter how dramatic and emotional it may seem at the time.
In the Season 3 finale of "Charmed," titled "All Hell Breaks Loose," one main character's death is nothing short of shattering. The episode finds the Halliwells facing off with Shax, and right in the middle of everything, they are publicly outed as witches by a reporter. Amid all of the ensuing chaos outside the manor, the sisters end up encountering an obsessive fangirl named Alice, who shoots Piper with a high-powered rifle. Thanks to the media circus outside their home, it takes far too long to get her to the hospital, and Prue stands by in agony, crying out for Leo as doctors fail to save her sister.
Luckily, Tempus resets the timeline back to the first encounter with Shax, saving Piper from the terrible fate. Unfortunately, Prue dies almost instantly in the fight, a fact that isn't revealed until the next season.