SQL_SMALL_RESULT

MySQL

Example

SELECT SQL_SMALL_RESULT product_name, product_price
FROM products
ORDER BY product_price;

Output

+------------------+---------------+
| product_name     | product_price |
+------------------+---------------+
| LED TV           | 350.99        |
| Refrigerator     | 700.50        |
| Washing Machine  | 500.75        |
| Air Conditioner  | 850.00        |
+------------------+---------------+

Explanation

The SQL_SMALL_RESULT modifier is used in the SQL query. It informs MySQL to store the result of the query in a temporary table, which then sorts the table. This is useful when expecting a small result set from a large database.