LookupOrderedRows
Returns a specified number of rows. You can specify multiple additional field and value pairs as part of an AND clause. The function returns an empty set when no values match.
Syntax
LookupOrderedRows(1, 2, 3, 4, 5)
Function Properties
| Ordinal | Type | Description | |
|---|---|---|---|
| 1 | string | Required | Name of data extension from which to return specified rows |
| 2 | numeric | Required | Number of rows to return. A value less than 1 returns the default 2000 rows. This limitation enhances script performance. |
| 3 | string | Required | Defines order of return as field ASC or field DESC |
| 4 | string | Required | Field to use to build WHERE clause |
| 5 | string | Required | Value to use to build WHERE clause |
Usage
This call returns the 4 rows from the Cars data extension with the highest horsepower that match the value specified by MPG.