Retrieve All Discontinued Products in SQL
Retrieve All Discontinued Products in SQL
Products Table:
Query Explanation:
● SELECT * → Selects all columns from the table.
● FROM Products → Targets the Products table.
● WHERE Discontinued = 1 → Filters only the discontinued products.
● Note: According to your data, all products have Discontinued = 0, so the query returns no rows.
Let me know if you want to mark any products as discontinued and recheck.
SQL Query:
USE SalesInventoryDB;
SELECT *
FROM Products
WHERE Discontinued = 1;
Output:
