SELECT * FROM (SELECT id, ShipAddress, ShipZIPPostal, ROW_NUMBER() OVER (PARTITION BY shipaddress,shipzippostal ORDER BY id) ROWNUM1, ROW_NUMBER() OVER (PARTITION BY shipaddress,shipzippostal ORDER BY id DESC) ROWNUM2 FROM orders WHERE CONVERT(DATE,orderdate) = CONVERT(DATE,GETDATE()) ) x WHERE ROWNUM1 <> ROWNUM2