What will the below query return

What will the below query return

SELECT TOP 10 GRADES FROM STUDENT;
A . The top 10 highest grades
B. The 10 lowest grades
C. Non-deterministic list of 10 grades

View Answer

Answer: C

Explanation:

An ORDER BY clause is not required; however, without an ORDER BY clause, the results are non-deterministic because results within a result set are not necessarily in any particular order. To control the results returned, use an ORDER BY clause.

n must be a non-negative integer constant. https://docs.snowflake.com/en/sql-reference/constructs/top_n.html#usage-notes