RE: [Hibernate-devel] New feature discussion (max query result list size)

[Anton v. S. <an...@ap...>]

> if you're going to change the language, their are at least 2
> other options :
>
> (a) oracle uses "WHERE ROWNUM<?"
>
> (b) informix uses "SELECT FIRST ?"

FWIW, Sybase/Microsoft T-SQL uses "SET ROWCOUNT n" to limit returned rows in
subsequent queries.  (later more Microsoft-specific SQL dialects may do it
differently.)