Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  How to not select record was selected

Author  Topic  abc Starting Member 48 Posts Posted - 2001-09-07 : 06:30:17 I have a table like this: ID Date Content 123 12-12-2001 kigk k jhkgkl 456 12-12-2001 kfks kljg fkjsd h 789 12-12-2001 kgjksf;k 123 12-11-2001 kdgl; 012 12-11-2001 kgk;fl;' In that I want to get a query select all record of today and the record of the daybefore, but if there is have a record of today selected so the record of the daybefore have the same ID with that record will be not select. What have I do, to get the result as: ID Date Content 123 12-12-2001 kigk k jhkgkl 456 12-12-2001 kfks kljg fkjsd h 789 12-12-2001 kgjksf;k 012 12-11-2001 kgk;fl;' Thanks Thanks