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 vote190 views1 answer
Postgres list tables and row counts
SQL
1 vote218 views1 answer
Mysql select all and rename one
SQL
0 vote204 views1 answer
Postgres grep entire database
SQL
17 votes258 views2 answers
How to assign date field for table in mysql
SQL
1 vote192 views4 answers
Fatal database postgres does not exist
SQL
0 vote208 views2 answers
Dumping sql table
SQL
0 vote194 views1 answer
How to use query in nosql
SQL
0 vote183 views1 answer
Sql string length postgresql
SQL
0 vote232 views1 answer
Select 1 from orders
SQL
0 vote185 views1 answer
Select all tables linked server sql
SQL