Enter and run your own SELECT statements, this is SQL Server 2012, my guitar sho

Question

Enter and run your own SELECT statements, this is SQL Server 2012, my guitar shop

In these exercises, you'll enter and run your own SELECT statements. Write a SELECT statement that returns four columns from the Products table: ProductCode, ProductName, ListPrice, and DiscountPercent. Then, run this statement to make sure it works correctly. Add an ORDER BY clause to this statement that sorts the result set by list price in descending sequence. Then, run this statement again to make sure it works correctly. This is a good way to build and test a statement, one clause at a time.

Explanation / Answer

SELECT ProductCode, ProductName, ListPrice, DiscountPercent FROM Products ORDERBY ListPrice DESC

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.