Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Visual Studio 2013 > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Clauses > WHERE Clause Syntax and Description > ORDER BY Clause > ORDER BY Example

ORDER BY Example

In the following sample query, the retrieved rows are first ordered by supplier number, and then by descending part number order -- within the same supplier number grouping.

SELECT sno, pno, qty
FROM partsupp
  ORDER BY sno, pno DESC

The query results are as follows:

sno pno qty
S1 P6 100
S1 P5 100
S1 P4 200
S1 P3 400
S1 P2 200
S1 P1 300
S2 P2 400
S2 P1 300
S3 P2 200
S4 P5 400
S4 P4 300
S4 P2 200
Parent topic: ORDER BY Clause
Previous Topic Next topic Print topic