Which of the clause is not mandatory?
(a) OVER clause
(b) ORDER BY clause
(c) PARTITION BY clause
(d) All of the mentioned
This question was addressed to me in a national level competition.
The question is from Ranking topic in portion Manipulating Data with Select of SQL Server