v.18.12Improvement

Using SELECT TOP n as an Alternative to LIMIT

Official CH changelog text
You can use the SELECT TOP n syntax as an alternative for LIMIT. #2840
Introduces the SELECT TOP n syntax as an alternative to the existing LIMIT clause.

Why it matters

This feature provides users with a more familiar and potentially clearer syntax for limiting the number of rows returned in a query, especially for those coming from other SQL dialects where TOP is commonly used.

How to use it

Instead of using LIMIT n, simply use SELECT TOP n at the beginning of your query. For example:

SELECT TOP 10 * FROM table_name

Related resources

PreviousNext