Sunday 6 October 2013

05. Write a query to display CreditCardID, CardNumber, and ExpYear of the credit cards that do not expire in the year 2005 and 2007.

select creditCardID, cardnumber, ExpYear
from sales.creditcard Expcept (select creditcardID,cardNumber,Expyear
from sales.creditcard
where Expyear=2005 or Expyear=2007)

No comments:

Post a Comment