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 vote140 views1 answer
Shell script to log mysql cpu usage
SQL
5 votes128 views1 answer
How to check nls format in oracle
SQL
0 vote128 views1 answer
Drop constraint in ms sql
SQL
1 vote138 views1 answer
Sql first day quarter
SQL
1 vote137 views1 answer
Round one decimal place mysql
SQL
1 vote126 views1 answer
Too many connections mysql
SQL
0 vote130 views1 answer
Pagination with row_number
SQL
0 vote131 views2 answers
Sql query in dax power bi
SQL
0 vote135 views1 answer
Sparql list all graphs
SQL
0 vote217 views1 answer
Database timezone
SQL