Tech Junkie Blog - Real World Tutorials, Happy Coding!: SQL: Checking ShippedDate Column For NULL

Sunday, June 19, 2016

SQL: Checking ShippedDate Column For NULL

Retrieve records with NULL value in the ShippedDate column in the Orders table in Northwind

SELECT OrderID, ShippedDate
FROM Orders
WHERE ShippedDate IS NULL

Retrieve records that is does not have NULL value in the ShippedDate column in the Orders table in Northwind

SELECT OrderID, ShippedDate
FROM Orders
WHERE ShippedDate IS NOT NULL




Similar Posts:


2 comments:


  1. Many entrepreneurs are exploring innovative ways to enhance their product designs, and one popular method is the dtf transfer process. This technique allows for high-quality, detailed images to be transferred onto various surfaces, making customization easier than ever. With its growing popularity, more businesses are incorporating dtf transfer into their production lines to meet customer demands for personalized items. As the technology advances, the possibilities for creative applications continue to expand.

    ReplyDelete