Good and easy one. Keep it up !!!

+1

Nice question hints a good weekend. Thanks kapil 🙂

Yesterday i learn something and today i got the chance test it. 🙂

That's the best thing about QoD.

Thanks Hugo.

Good one Hugo.

Slawomir Swietoniowski (5/12/2013)

---

This question is stated wrong, cont(...) does not have any alias for the name, so, while you will try to execute this code, you will get:

Msg 1038, Level...

Good Basic question. But i surprised that still 51% people are wrong. :w00t:

Good question, but Explanation is not completed or require more details.

I think hugo can help us.

unfortunately, i trapped in this question. :crying:

But i learn something new. 🙂

Thanks reddy

tricky question for me. need more time to solve.:doze:

Thanks Hugo 🙂

Still nobody forget yesterday QOD experience. :w00t:

kapil_kk (5/6/2013)

---

Thanks Vinay for the question... 🙂

I was not aware of the thing that if we use DISTINCT then Column names specified in the ORDER BY clause, must be defined...

🙂

Qotd yesterday :w00t::w00t::w00t:

I think author did mention it clearly that execute all statement in a single batch.

Due to that i lose my points..:doze:

Most of people don't know about it because it's not in use in any real scenario. I never use this kind of table in production environment, But i knew it...