But do you look like your avatar, Roy?

P.S. It's good to see you back online. I can't remember if I said that earlier.

If I sounded like my avatar, it would be some kind of klaxon/alarm bell/buzzer/siren/end-of-the world noises. 😀

By the way, I'm now having to deal with a table named...

Flo: I was being a trifle ironic, maybe even a touch sarcastic. 😉

Although, I am sorry to say, I have at times written queries containing...

Why shouldn't he put quotes around 'NULL', Alvin?

'NULL' is a perfectly good word. Isn't it? :unsure:

BTW, I was also crushed when...

You always have the option to avert your eyes and let others assist him.

They might give him bad advice though.

He might even take it.

BTW, if I ever...

Hey Lynn:

He probably learned about SSC early in his academic career, maybe even got hired with the help of SSC, and may get his Ph.D. with SSC assistance as well....

I misunderstood, sorry about that. You are wanting to build the values you originally posted.

A summary query either before or after would give you...

Feels good, doesn't it? 😉

Um.... yeah..... :w00t: I obviously haven't had enough caffeine this morning.

What's ridiculous about cutting 25% of the work out? If you can do that with everything that runs on your SQL server, you are doing well.

I assume you are partitioning on column 3, and that by "top-ranked" you mean the rows where row_number() = 1.

I'm changing up the data a bit in the example below...

Tables have fields???? 😀

No problem. Did any of the answers posted work for you?

I was waiting for you to post up the samples I requested, partner. 😉

By failing to do that, you have people guessing at...

That's cool and sort of lovely, Gail. Thanks for sharing.