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 vote203 views1 answer
Oracle list of long running queries
SQL
0 vote186 views1 answer
Mysql earlier than date
SQL
1 vote232 views1 answer
Homebrew install mysql
SQL
0 vote221 views1 answer
Sql get count without group by
SQL
0 vote203 views4 answers
Change schema in sql server
SQL
0 vote204 views2 answers
How do I UPDATE from a SELECT in SQL Server?
SQL
0 vote199 views1 answer
Setval postgres example table id
SQL
0 vote197 views2 answers
How to find max and min salary in sql
SQL
0 vote206 views2 answers
Postgresql get last day of month
SQL
1 vote201 views2 answers
Sql left characters
SQL