The MIDDLE keyword, like the FIRST, can specify a maximum number of rows to retrieve that match conditions specified in the SELECT statement. The FIRST option returns the first max rows (for max substitute a number that you specify) that satisfy the selection criteria, but the MIDDLE option returns max rows from the middle of the set of qualifying rows.
The syntax and restrictions for this option are the same as those for the FIRST option. For more information, see Using the FIRST Option.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]