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 vote122 views1 answer
Select insert new table sql server
SQL
0 vote118 views1 answer
Mysql make date from 2 column
SQL
0 vote102 views1 answer
INSERT INTO table using OpenQuery
SQL
0 vote145 views1 answer
Ms sql print more than 1 variable
SQL
6 votes111 views2 answers
Mysqldump password in file
SQL
1 vote100 views1 answer
Oracle finding duplicate records
SQL
0 vote63 views2 answers
Denormalization in sql
SQL
0 vote172 views1 answer
Mariadb date equals to current_date plus days
SQL
1 vote76 views5 answers
Spring boot sql logging
SQL
0 vote109 views1 answer
How to Group by and concatenate arrays with all columns in PostgreSQL
SQL