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 vote326 views1 answer
How to drop a trigger in postgresql
SQL
11 votes308 views1 answer
How to get ddl for materialized view
SQL
0 vote347 views1 answer
Oracle exchange subpartition
SQL
0 vote303 views2 answers
Select limit ms sql
SQL
2 votes326 views1 answer
Oracle calculated column
SQL
0 vote322 views1 answer
Windows services sql
SQL
3 votes332 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote411 views1 answer
Create view in sql server that contain multiple select statements
SQL
0 vote352 views1 answer
What is SQL data store?
SQL
18 votes311 views2 answers
Sql inner join
SQL