Which rows are returned when using LIMIT with OFFSET in MySQL

Question

In the query below   SELECT column  FROM table LIMIT 18 OFFSET 8   how many results will we get as output and from where to where

User · Answer

OFFSET is nothing but a keyword to indicate starting cursor in table  SELECT column FROM table LIMIT 18 OFFSET 8 -- fetch 18 records  begin with record 9  OFFSET 8    you would get the same result form  SELECT column FROM table LIMIT 8  18   visual representation  R is one record in the table in some order    OFFSET        LIMIT          rest of the table                                                                   RRRRRRRR RRRRRRRRRRRRRRRRRR RRRR                                                                 your result

User · Answer

You will get output from column value 9 to 26 as you have mentioned OFFSET as 8

User · Answer

It will return 18 results starting on record  9 and finishing on record  26   Start by reading the query from offset  First you offset by 8  which means you skip the first 8 results of the query  Then you limit by 18  Which means you consider records 9  10  11  12  13  14  15  16    24  25  26 which are a total of 18 records      Check this out   And also the official documentation

[mysql] Which rows are returned when using LIMIT with OFFSET in MySQL?

Examples related to mysql