title: How to generate SQL statement with LIMIT clause but without OFFSET clause in jOOQ?
body: <p>I'm trying to use jOOQ to generate the following SQL statement:</p>
  
  <pre><code>SELECT id, name
  FROM students
  ORDER BY id DESC
  LIMIT 50;
  </code></pre>
  
  <p>To generate the above statement with jOOQ:</p>
  
  <pre><code>String sql = DSL.using(SQLDialect.POSTGRES).select(
    field("id"),
    field("name"))
    .from("students")
    .orderBy(field("id").desc())
    .limit(inline(50))
    .getSQL();
  </code></pre>
  
  <p>But I get the following:</p>
  
  <pre><code>select id, name from students order by id desc limit 50 offset ?
  </code></pre>
  
  <p>How do I remove the <code>OFFSET</code> clause? I know that I can specify the offset value to 0, which is same as omitting the <code>OFFSET</code> clause, but I want to know whether I can completely remove it from the generated SQL statement.</p>
  
  <p>Thank you.</p>