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

From ZCubes Wiki
Revision as of 22:51, 4 November 2013 by MassBot1 (talk | contribs) (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 the ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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;