Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

Namespace: NHibernate.Dialect
Assembly: NHibernate (in NHibernate.dll) Version: 3.2.0.4000 (3.2.0.4000)

Syntax

C#
public virtual bool UseMaxForLimit { get; }
Visual Basic
Public Overridable ReadOnly Property UseMaxForLimit As Boolean
	Get
Visual C++
public:
virtual property bool UseMaxForLimit {
	bool get ();
}

Return Value

True if limit is relative from offset; false otherwise.

Remarks

This is easiest understood via an example. Consider you have a table with 20 rows, but you only want to retrieve rows number 11 through 20. Generally, a limit with offset would say that the offset = 11 and the limit = 10 (we only want 10 rows at a time); this is specifying the total number of returned rows. Some dialects require that we instead specify offset = 11 and limit = 20, where 20 is the "last" row we want relative to offset (i.e. total number of rows = 20 - 11 = 9) So essentially, is limit relative from offset? Or is limit absolute?

See Also