Fetch First Clause (SQL)

Help Contents


The SQL Fetch First clause sets the number of rows to return in the query result.


fetch-first-clause ::=
  FETCH { FIRST | NEXT } [ row-count ] { ROW | ROWS }


row-count is an optional constant integer value or parameter that is greater than or equal to one. The value sets the maximum number of rows to return in the query result. If row-count is omitted, the maximum rows returned in the query result is one.

The keywords FIRST and NEXT are synonyms.

The keywords ROW and ROWS are synonyms.


To fetch the first 5 digital tags:

Select FullName,Value,Quality
From TagDataPointDigital
Fetch First 5 Rows

Further Information

Fernhill SCADA Structured Query Language (SQL)

To learn more about the SQL features in Fernhill SCADA.


For the meaning of terms used in Fernhill SCADA.