Welcome Back

Google icon Sign in with Google
OR
I agree to abide by Pharmadaily Terms of Service and its Privacy Policy

Create Account

Google icon Sign up with Google
OR
By signing up, you agree to our Terms of Service and Privacy Policy
Instagram
youtube
Facebook

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.

SQL Query:

USE SalesInventoryDB;

SELECT *  
FROM Products  
WHERE Discontinued = 1;

 

Output: