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.
| Author |
Topic |
|
ngl4711
Starting Member
1 Post |
 Posted - 2007-02-03 : 21:32:30
|
| Hello I am working in an advertising company and I have to find all records who have advertised 7 days back but if one person has advertised more than once means for different products, his name should come only once. How can I filter this. I am totally new to this language I can write simple query but don’t know how to filter it.Name IndividualID Product DateA 1 x 2007-01-27.23.59.59.777A 1 y 2007-01-28.00.00.00.000b 2 xx 2007-01-28.00.00.00.000A 1 z 2007-01-28.00.00.00.000b 2 yy 2007-01-28.00.00.00.000A 1 p 2007-01-28.00.00.00.000c 3 m 2007-01-28.00.00.00.000d 1 n 2007-01-28.00.00.00.000A 1 s 2007-01-28.00.00.00.000 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-03 : 23:52:07
|
[code]select distinct Namefrom tablewhere Date >= dateadd(day, datediff(day, 0, getdate()), -7)[/code]
KH |
 |
|
|
|
|
|
Filter Help