Sign in with Google
Retrieve All Orders with a NULL ShipperID in SQL
Retrieve All Orders with a NULL ShipperID in SQL
Orders Table:
Query Explanation:
● SELECT * – Retrieves all columns from the table.
● FROM Orders – Indicates that the data should be fetched from the Orders table.
● WHERE ShipperID IS NULL – Filters the results to show only those orders where the ShipperID is not assigned (NULL).
SQL Query:
USE SalesInventoryDB;
SELECT *
FROM Orders
WHERE ShipperID IS NULL;
Output:
