How would you sort the results first by "date" in ascending order and then by "amount" in descending order? SELECT * FROM expenses ORDER BY date ASC, amount DESC; SELECT * FROM expenses ORDER BY date DESC, amount ASC;SELECT * FROM expenses SORT BY date ASC, amount DESC;SELECT * FROM expenses ORDER BY date, amount;

Which SQL clause is used to sort the result set in descending order based on one or more columns?

ORDER BY and GROUP BY clauses can be used to sort the results in a specific order.

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? SELECT * FROM Persons SORT BY 'FirstName' DESC SELECT * FROM Persons ORDER BY FirstName DESC SELECT * FROM Persons SORT 'FirstName' DESC SELECT * FROM Persons ORDER FirstName DESC

Consider the table account given below :Requirement:Jack and John are given the requirement to retrieve the account details and sort details according to location (alphabetically) and in decreasing order of the amount in each of that locations.Jack :SELECT custno, accountno, ifsccode, location, amount, accounttype FROM account ORDER BY location ASC, amount DESC;John :SELECT custno, accountno, ifsccode, location, amount, accounttype FROM account ORDER BY 5 DESC, 4 ASC;Whose query will be correct to satisfy the above requirements?

What is the purpose of the ORDER BY clause in a SQL SELECT statement?To specify which columns to retrieve from the table.To filter rows based on a specified condition.To group rows with the same values into summary rows.To sort the results in ascending or descending order.Next