Reminds me of Synchronicity II.
The high notes aren’t exceptionally high compared to the rest of the notes but it’s deceptive. It sounds like the standard new wave/emo/Eleanor Rigby whine except that it’s a few notes higher than them, so when I actually tried to sing it in Rock Band my balls almost dropped off 
“Under Pressure” - Queen/David Bowie
‘Whhhyyyyyyyyyyyyyyyyyyy’
I was at a party this summer that had one of the best cover bands I’ve ever heard. When they played the opening riff to this song, I thought, “No way this singer (who was really drunk) is going to pull this off.”
He did - dead on.
I can’t sing for sh*t, but I love trying to sing along to this in the car. I almost made myself throw up once. 
I don’t know if she counts as rock, but Kate Bush “Wuthering Heights”
Chris Cornell of Sound Garden/Temple of the Dog - “Say Hello to Heaven” and various other early stuff was rediculous. That guy was the man.
Damn impressive
A lot of Don Henley high notes in the Eagles, the big one that comes to mind is the ending of The Last Resort…
“…kiss it goodbye yyyyyyyyyyyyyyyyyyeeeeeeeeeeeeeeeeeeiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiii…”
Tiny Tim, who could rock when he wanted to.
Maybe Zebra’s only a Long Island tradition, but “Tell Me What You Want” certainly has high enough notes to fit the OP’s request (and yes, we here consider them a rock band).
Young American by David Bowie - “Break down and Cryyyy”
Respect by Erasure.
“Give a little respect to-oo-oo-ooo MEEEEEEEEEEEE!”
Gotta mention Geoff Tate from Queensryche here. There’s an iconic high note from “Take Hold of the Flame” just before the song starts rockin’ which needs to be #1 on this list.
How about Jon Anderson of Yes? All over songs like “Long Distance Runaround” and “Heart of the Sunrise.”
Also “Exciter”:
Stand by for exciter…
[/higher]Stand by for exciter…
[/even higher]Stand by for exciter…
[/omfg]Stand by for exciter…
Not only did he have a pretty wide range but his vocal cords and lungs must have been made by the local ironworks.
“Wow-ow-ow-OW sweet child of miiiiiine”
Also, Jeff Buckley and ‘Last Goodbye’
I suddenly had a “Wayne’s World” moment…:smack:
“Gonna Get Close To You” from Queensryche comes to mind, along with a large chunk of their catalog [mmm, Geoff Tate…]
Beatcha at #11. Sorry, but I so rarely get to do this!
Also the cheesy pop balled, “Time Will Reveal,” (“cause thiiiiis time loooove’s for real” near the end.)
Oooh, lots by Prince, especially that “oooh”, in “When Doves Cry”, but he hits some fairly bizarre notes in a lot of his songs!
Gotta love Kate! “Song of Solomon.”
At 2:51 (and repeating thereafter), what note is that?
Peter Gabriel at the end of “Shock the Monkey.”
He hits some pretty high notes on the way, but then at 3:43…:eek:
If we’re going to mention Minnie Ripperton I guess we better throw in Mariah Carey, “Someday,” at 3:45
http://www.youtube.com/watch?v=ZzLlKW81848 :eek::eek::eek::eek::eek:
Well if you’re going to mention Mariah Carey, then “Emotions” goes higher, I think.
Tori Amos, in “Yes Anastasia” has one note that goes up three times until it’s ridiculous. You can hear it at about the 8:17 mark.
James Brown has one ear-splitter in “Superbad” at around 3:55 that isn’t even a word, it’s just a shriek following a string of “Gimme!” Scares the cats. This is a great song because of all the hehs and huhs and ayes and random phrases, including “Sometimes I feel so nice, I wanna try myself with you, huh!”