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

7 votes213 views3 answers
Sql get last inserted row
SQL
4 votes219 views2 answers
Postgres update single column
SQL
0 vote244 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote204 views1 answer
Display total number of tables in mysql
SQL
0 vote224 views1 answer
How to declare variable date in mysql
SQL
0 vote225 views1 answer
Sql server select record with max id
SQL
2 votes229 views2 answers
Postgres trigger insert into another table
SQL
9 votes227 views3 answers
Import DB through mysql console
SQL
0 vote245 views1 answer
Psql initialization
SQL
0 vote217 views1 answer
To change the database owner in SQL server
SQL