SOL-C01 practice question 8 of 30
What is the typical syntax for using the LIMIT clause to retrieve the first 10 rows of a table named employees?
Full set: 214 questionsThe LIMIT clause in Snowflake SQL is used to restrict the number of rows returned by a query. The correct and standard syntax places the LIMIT clause at the end of the SELECT statement, after the FROM and any WHERE, GROUP BY, or ORDER BY clauses. The syntax SELECT FROM employees LIMIT 10; correctly requests all columns () from the employees table and returns only the first 10 rows encountered.
B. SELECT LIMIT 10 ... is syntactically incorrect; LIMIT is not part of the column selection list in the SELECT clause.
C. LIMIT 10 SELECT ... is syntactically incorrect; the SELECT statement must come first.
D. ... WHERE LIMIT 10; is syntactically incorrect; LIMIT is a clause that constrains the final result set, not a condition within the WHERE clause.
1. Snowflake Documentation. (n.d.). SELECT. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/sql/select. The syntax summary shows [ LIMIT ] as one of the final clauses of a SELECT statement.
2. Snowflake Documentation. (n.d.). LIMIT / FETCH. Snowflake Inc. Retrieved from https://docs.snowflake.com/en/sql-reference/constructs/limit. The documentation provides examples such as SELECT FROM mytable LIMIT 10;, confirming this structure.
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
