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 vote178 views4 answers
Mysql count table rows
SQL
1 vote193 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote192 views1 answer
SQL FROM-Klausel
SQL
1 vote183 views1 answer
Crontab every month
SQL
18 votes185 views6 answers
Create table mysql
SQL
1 vote197 views2 answers
Mysql switch case
SQL
0 vote197 views1 answer
Exectuer myssql .sql
SQL
2 votes202 views1 answer
SQL column name Postgre
SQL
0 vote216 views1 answer
What is common table expression in sql
SQL
7 votes186 views2 answers
What is sql clause
SQL