Find Products with Price Greater Than 100 in SQL
Find Products with Price Greater Than 100 in SQL
Products Table:
Query Explanation:
● SELECT * – Retrieves all columns from the table.
● FROM Products – Specifies the Products table to query from.
● WHERE UnitPrice > 100 – Filters and returns only those products whose price is greater than 100.
SQL Query:
USE SalesInventoryDB;
SELECT *
FROM Products
WHERE UnitPrice > 100;
Output:
