Difference between revisions of "Yurttas/PL/DBL/mysql/F/01/00/bank/BankTwo/o02.sql"
Jump to navigation
Jump to search
(Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">/* REM REM o02.sql REM REM List the entire borrow relation in descending order of amount, REM if several loans have th...") |
(No difference)
|
Latest revision as of 16:08, 3 November 2013
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;