Yurttas/PL/DBL/oracle/F/01/Bank/o02.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM o02.sql
 3REM
 4REM List the entire borrow relation in descending order of amount,
 5REM if several loans have the same amount, order them
 6REM in ascending order by loannumber.
 7REM
 8
 9SELECT *
10FROM Borrower
11ORDER BY amount DESC,
12	 loannumber ASC;