Hugo Kornelis (1/7/2016)

---

Hugo Kornelis (1/7/2016)

---

Rune Bivrin (1/7/2016)

---

Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up...

Hugo Kornelis (1/7/2016)

---

Also note that the syntax diagram suggests that not only the ORDER BY clause, but also the OVER clause itself is mandatory (though the text of the article...

Interestingly enough, the most recent docs for COUNT() states that the OVER() requires the ORDER BY clause, which is patently untrue, at least up to SQL 2012....

Where can I buy SQL Server 2015?:hehe:

webrunner (11/10/2015)

---

I knew that...

Thanks for this one! Got it wrong and learned something quite useful.

I was very torn between "3" and "Not supported". Based on the following in the cited documentation, I kind of felt both were correct:

The FIRSTROW attribute is not intended to...

ISQL/W... Pftt! New-fangled stuff.

I remember when I did most of the work in SAF on SQL Server 1.1. Those were the days...

Which is it? Is...

Can't really say anything positive about a question which relies on regional settings for correct answer, and which doesn't really promulgate any useful knowledge. Why would I want to do...

In Sweden, the legal minimum is 25 days of fully paid vacation, but many have 30 or more paid days off. All countries in the European Union have at least...

More tsk, tsk.

There, now I've got the two points.:hehe:

Tsk, tsk.

Mighty (1/7/2015)

---

In relation to this, I don't fully agree. For me...

Not fond of this question.

COUNT(*) counts NULL:s, but COUNT(<expression>) doesn't.

select count(*), count(a)

from (values (1), (NULL)) x(a)

And GROUPING most certainly considers NULL:s.