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 vote343 views1 answer
Django mssql backend
SQL
-1 vote322 views1 answer
How to use update trigger in sql
SQL
3 votes374 views4 answers
Truncate syntax in sql
SQL
5 votes397 views3 answers
Sql limit offset
SQL
14 votes319 views2 answers
Sql cast
SQL
18 votes362 views3 answers
Mysql add column default value
SQL
1 vote338 views1 answer
Mysql view command
SQL
0 vote346 views1 answer
Postgres select from values
SQL
0 vote349 views1 answer
Transalations from sql to Linq count and group by
SQL
0 vote316 views1 answer
Mysql max number not returning correct value
SQL