First Table Rows
Returns a table containing one of the following:
First
n rows of a specified table, for a specified number,
n.
First
n rows for each unique combination of values in a specified set of columns in a specified table, for a specified number,
n.
Arguments
This function has the following arguments:
Table: Table some of whose rows are to be returned.
Index Column Names: Text string that specifies the column or columns to be used to form indexes. Separate column names with a semicolon. If this argument is not supplied, the function returns the first
Number of Rows of
Table. If this argument is supplied, the function forms indexes by concatenating the values contained in each index column, and returns
Number of Rows rows for each index.
Number of Rows: Numerical value that specifies the number rows to be returned, or the number of rows with each index value to be returned.
The function returns a table.
Copyright © 2013
Software AG, Darmstadt, Germany and/or Software AG USA Inc., Reston, VA, USA, and/or Terracotta Inc., San Francisco, CA, USA, and/or Software AG (Canada) Inc., Cambridge, Ontario, Canada, and/or, Software AG (UK) Ltd., Derby, United Kingdom, and/or Software A.G. (Israel) Ltd., Or-Yehuda, Israel and/or their licensors.