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

1 vote284 views1 answer
Select tables with name like mysql
SQL
3 votes258 views1 answer
Oracle function
SQL
0 vote282 views1 answer
Product of a column in mysql
SQL
25 votes293 views4 answers
Sqlserver add column
SQL
18 votes278 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote294 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
2 votes280 views1 answer
Add default sql server
SQL
32 votes304 views6 answers
Insert select
SQL
2 votes332 views3 answers
Sql delete duplicate
SQL
1 vote263 views1 answer
Postgres format date in select
SQL