Search results
The ORDER BY clause specifies the particular order in which you want selected rows returned. The order is sorted by ascending or descending collating sequence of a column's or an expression's value.
This tutorial shows you how to use the the Db2 ORDER BY clause to sort the result of a query in ascending or descending order.
17 maj 2010 · You can use a window function in a sub-query in order to simulate TOP N: select * from ( select id, row_number() over (order by id) as rn from testsch.testtbl ) as r where r.rn < 100 -- This is N rows you are looking for This will return exactly 99 rows. I tried that in iSeries 7 and it worked.
To sort by descending order, the keyword DESC must be specified. SELECT ProductID, ProductName, Price FROM Product ORDER BY Price DESC; This SQL sorts the products by Price in descending order (most expensive product present first).
By default, ORDER BY sort the data in ascending order. We can use the keyword DESC to sort the result set in the descending order and the keyword ASC to sort the result set in ascending order. The column specified in the ORDER BY clause does not need to be included in the SELECT clause.
9 gru 2005 · Re: sort by decending order Hi, I'd solve this problem by using embedded SQL. The select statement in the declare cursor statement must be something as follows:
The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.
