EasyBasic SELECT
Show all products with their category id sorted by price
The query
SQL
SELECT product_id, name, cat_id, price, stock
FROM products
ORDER BY price ASC;Note
“ASC is default but explicit is always better for code readability.
SELECT product_id, name, cat_id, price, stock
FROM products
ORDER BY price ASC;Note
“ASC is default but explicit is always better for code readability.