Tesco: Order by and Limit

Full Name

Email ID

Which of the following statements about ORDER BY is true?

• ORDER BY is used to filter records based on a condition.

• ORDER BY sorts query results in ascending order by default.

• ORDER BY can only be used with numeric columns.

• ORDER BY must always be used with the LIMIT clause.

You are analyzing sales data for a retail company. Your manager wants a report showing the top 5 highest-selling products based on revenue. Which SQL query will you use?

• SELECT product_name, SUM(revenue) FROM sales ORDER BY revenue DESC LIMIT 5;

• SELECT product_name, SUM(revenue) FROM sales ORDER BY revenue ASC LIMIT 5;

• SELECT product_name, SUM(revenue) FROM sales LIMIT 5 ORDER BY revenue DESC;

Which statement about ORDER BY sorting order is true?

• If no order is specified, SQL automatically sorts in descending order.

• ORDER BY supports both ASC (ascending) and DESC (descending) sorting.

Which of the following queries correctly orders the data first by age in descending order and then by name in ascending order?

• SELECT name, age FROM employees ORDER BY age DESC, name ASC;

• SELECT name, age FROM employees ORDER BY name ASC, age DESC;

• SELECT name, age FROM employees ORDER BY age, name DESC;

• SELECT name, age FROM employees ORDER BY name and age DESC;

What happens when you use LIMIT without ORDER BY in a query?

• It retrieves the first N rows in an unspecified order.

• It retrieves the first N rows in ascending order.

• It retrieves the first N rows in descending order.

• SQL throws an error.