java

PostgreSQL: Add Limit Parameter

In Oracle I can have an SQL string like this

select * from table where rownum <= ?

Then in an PreparedStatement I can set the rownum as a parameter.

How does it work with Postgres JDBC (Java) with the LIMIT clause? Doing the following won’e let me set a parameter:

select * from table limit ?

You need to sign in to view this answers