Yurttas/PL/DBL/mysql/F/01/00/bank/Bank/o02.sql

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