W3. SQL Order By

Question 1

Q: What is the purpose of the SQL ORDER BY keyword?

Answer 1

A: To sort the result set in ascending or descending order.

Question 2

Q: Write a SQL query to sort products by price in ascending order.

Answer 2

SELECT * FROM Products 
ORDER BY Price;

Question 3

Q: What is the default order for sorting when using ORDER BY?

Answer 3

A: Ascending order.

Question 4

Q: How do you modify ORDER BY to sort results in descending order?

Answer 4

A: Add the DESC keyword after the column name.

Question 5

Q: Write a query to sort products from highest to lowest price.

Answer 5

SELECT * FROM Products 
ORDER BY Price DESC;

Question 6

Q: How does ORDER BY sort string values?

Answer 6

A: Alphabetically by default.

Question 7

Q: Write a query to sort products alphabetically by ProductName.

Answer 7

SELECT * FROM Products
ORDER BY ProductName;

Question 8

Q: How do you sort a column in reverse alphabetical order?

Answer 8

A: Use the DESC keyword after the column name.

Question 9

Q: Write a query to sort products by ProductName in reverse alphabetical order.

Answer 9

SELECT * FROM Products 
ORDER BY ProductName DESC;

Question 10

Q: How can you sort by multiple columns in SQL?

Answer 10

A: List the columns in ORDER BY, separated by commas.

Question 11

Q: Write a query to sort customers by Country and then by CustomerName.

Answer 11

SELECT * FROM Customers
ORDER BY Country, CustomerName;

Question 12

Q: How do you specify different sort orders for multiple columns?

Answer 12

A: Use ASC or DESC for each column in the ORDER BY clause.

Question 13

Q: Write a query to sort customers by Country in ascending order and CustomerName in descending order.

Answer 13

SELECT * FROM Customers
ORDER BY Country ASC, CustomerName DESC;