I wonder if the missing quote was intentional, just to make us think harder, or an error.

The sarted out by thinking that we are told the table holds that data...

duplicate - deleted.

Ed Wagner (11/30/2014)

---

There also has to be a good mechanism for blocking posts that doesn't drag down the site's performance. I think that poor performance is worse than lots...

Now 167.

Needs quite a few more vote, I think.

voted.

It's now 167. Not growing fast enough.

marcia.j.wilson (11/24/2014)

---

TomThomson (11/24/2014)

---

Nice question, but I have two queries about it:

(i) why 2 points? it's just extremely simple logic.

(ii) why use first_value and DESC when last_value would do, so...

TheSQLGuru (11/23/2014)

---

TomThomson (9/25/2014)

---

I don't understand it at all. An interesting twist is...

Easy question.

Correct answer, but utterly useless references. The first doesn't even mention maintenance plans. The second says they can't be used to do bakups for a database that...

I thought everyone knew it was teh day when 2 turkeys got preseidential pardons.

Kev T (11/25/2014)

---

Thanks Paul, how interesting! I wonder how this is handled in Greece with regards to big data and historical records, or if they forgone the lost days...

But more than half the answers so far were wrong! (Probably because people forgot about negative integers, I guess.)

Hugo Kornelis (11/26/2014)

---

Sorry for the harsh words, but this is absolute rubbish.

The code in option 2 will always do two lookups. One for the EXISTS, and then another one for...

Nice question, but I have two queries about it:

(i) why 2 points? it's just extremely simple logic.

(ii) why use first_value and DESC when last_value would do, so that the...

edwardwill (11/24/2014)

---

The question asked:

Which of the following will return only the Id of the most recent post for each Author?

The correct answer should have been "None of the above",...

I must be lucky, I can see twice as many non-spam...