sql STATEMENT HELP ????

Question

How would write this as an sql statement???

Show all columns from the StockItem table in descending Selling Price sequence.
Where more than 1 item has the same selling price, ensure that the items are listed in
ascending Description sequence.

Select *
From Stock item table.....????

Answer 1

You can use this SQL statement:



SELECT * FROM StockItem ORDER BY SellingPrice DESC, DESCRIPTION, ASC



You can look here for more information on the ORDER BY statement.

http://www.w3schools.com/sql/sql_orderby.asp

Answer 2

SELECT *

FROM StockItem

ORDER BY SellingPrice DESC, Description

Answer 3

Nick's answer is almost correct, just that there should not have been a comma between description and ASC (ASC could probably have been omitted entirely for that matter, as that's the default).