Sql fetch next 10 rows pdo

// You could have your values in variables (or hardcoded)
$offset = 0;
$limit = 5;

$statement = $pdo->prepare('SELECT * FROM livro ORDER BY id OFFSET :offset ROWS FETCH NEXT :limit ROWS ONLY');

// Next you need to bind the values
$statement->bindValue(':offset', (int) $offset, PDO::PARAM_INT); 
$statement->bindValue(':limit', (int) $limit, PDO::PARAM_INT); 

// Now execute your statement
$statement->execute();

Source: stackoverflow.com

Similar codes

0 vote211 views1 answer
Sql find gaps in date ranges
SQL
1 vote201 views1 answer
Altrer name column postgres
SQL
0 vote203 views1 answer
Check connections to database postgres
SQL
6 votes198 views2 answers
Difference between join vs union
SQL
2 votes194 views1 answer
Get hour from date sql
SQL
0 vote199 views1 answer
Create table as select sql server error
SQL
0 vote187 views1 answer
Select count postgres double row count > 1
SQL
0 vote193 views1 answer
Mariadb datetime change to microseconds
SQL
0 vote143 views1 answer
Oracle sql replace string in clob
SQL
1 vote204 views2 answers
Backup table mssql
SQL