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

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

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments