3000 explained code solutions for 75 technologies


clickhouseUsing LIMIT OFFSET in queries


SELECT * FROM tbl LIMIT 2 OFFSET 3ctrl + c
tbl

table to select data from

LIMIT

how many rows to show in result set

2

show only 2 rows

OFFSET

how many rows to skip from beginning

3

skip 3 rows before selecting data