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 vote161 views1 answer
Select all same column value in sql
SQL
22 votes163 views4 answers
Date format mysql
SQL
3 votes175 views2 answers
Update part of a string in mysql
SQL
0 vote154 views1 answer
Mysql order by where condition sub query
SQL
0 vote176 views1 answer
Copy from one table to another postgres using matching column
SQL
0 vote159 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
2 votes131 views1 answer
Get first 3 letters name in sql
SQL
6 votes142 views3 answers
Mysql first day of year
SQL
0 vote144 views2 answers
Mysql dump database tables only
SQL
22 votes204 views4 answers
Mysql date format
SQL