Consider the table:
Name Date Amount
John 1/1/2009 120
Chris 1/7/2009 45
Mary 1/2/2009 35
John 1/18/2009 100
Chris 1/1/2009 20
I need to select all records except those where name is John or Chris And date is 1/1/2009. So my query should retrieve only records 2,3 and 4. What SQL should I use?