List Loan Data Ordered By Decreasing Amounts Then Increasing #546
This subjective question is related to the book/course gs gs114 Relational Database Management System. It can also be found in gs gs114 Practical Questions Solved Past Paper No. 1.
Question 1: List loan data, ordered by decreasing amounts, then increasing loan numbers.
Answer:
select * from loan order by amount desc, loan_number asc;