An SQL statement returns data in a table called a result table.
You can specify certain attributes of the result table, such as the column
names, how the rows are ordered, and whether the rows are numbered.
Result tables result table . Like the tables from which you retrieve the data, a result table has rows and columns. A program fetches this data one row at a time.Excluding duplicate rows from the result table of a query Db2 to exclude multiple identical rows from a query result table. For example, a query might return multiple rows for each employee when one row per employee is sufficient for your program.Naming result columns Ordering the result table rows Db2 can return the rows in any order.Numbering the rows in a result table Db2 does not number the rows in the result table for a query unless you explicitly request that the rows be numbered.Ranking the rows Db2 calculate the ordinal rank of each row in the result set based on a particular column. For example, you can rank finishing times for a marathon to determine the first, second, and third place finishers.