limit sqlite

Kirilchik answered on July 3, 2023 Popularity 8/10 Helpfulness 3/10

answer limit sqlite

Comment

LIMIT is added to the end of the query

SELECT
	column_list
FROM
	table
LIMIT row_count;

OFFSET lets you choose from where to "start"

With the query below if you have a total of 20 rows it will pull the last 10,

as it offsets you from the start

SELECT
	column_list
FROM
	table
LIMIT 10 OFFSET 10;

Popularity 8/10 Helpfulness 3/10 Language sql

Source: Grepper

Tags: limit sql sqlite

Link to this answer
Share Copy Link

Contributed on Jul 03 2023

Kirilchik

0 Answers Avg Quality 2/10

Oops, You will need to install Grepper and log-in to perform this action.