Question

I am looking for help developing a SQL query that uses the MINUS operator to reproduce the following problem:

SELECT [CustFirstName]
   ,[CustLastName]
   FROM [OrderEntryBMIS325].[dbo].[Customer]
   WHERE [CustState] = 'CO' AND [CustNo] NOT IN (SELECT [CustNo]
                                               FROM [OrderEntryBMIS325].[dbo].[OrderTbl]
                                               WHERE [OrdDate] like '2013-Jan%') ;

Answer 1

Answer is as follows :

MINUS operator in SQL helps us to find the table in which data of first statement is present but data of second one is eliminated.

So MINUS query for given scenario is :

SELECT [CustFirstName] ,[CustLastName]
FROM [OrderEntryBMIS325].[dbo].[Customer]
WHERE [CustState] = 'CO'

MINUS

SELECT [CustNo]
FROM [OrderEntryBMIS325].[dbo].[OrderTbl]
WHERE [OrdDate] like '2013-Jan%' ;

The query will find custFirstName and custLastName form given table where CustState is "CO" but eliminate those customers where ordDate be like 2013-Jan% .

if there is any query please ask in comments...