sql - How to get duplicate values in all rows filtering by one column -

sql - How to get duplicate values in all rows filtering by one column -

here table looks like.

person date entry person1 05-20-14 142 person2 05-20-14 443 person1 05-21-14 248 person1 05-21-14 142

i need 2 things.

first number of times person made entry first time.

i tried doing these queries. problem need info per day.

that if query 05/21, need see output

"person1 1"

142 wont included because exists.

in query, filtering date already, not sure how go out , search in rest of dates values. here have.

select person, count(distinct entry) [table] date >= 05/21/2014 , date < 05/22/2014 grouping person order person.

this gives me

person1 2

both 248 , 142 considered here. how 142 entry made in previous dates. not @ nested queries.

thanks looking.

will solve problem or give thought how inner query should be?

select person, count(distinct entry) [table] date >= 05/21/2014 , date < 05/22/2014 , entry not in (select distinct entry [table] date <> 05/21/2014) grouping person order person.

in above query have added inner query distinct entry other dates

select distinct entry [table] date <> 05/21/2014

and have added status current result should not consider entries

and entry not in (select distinct entry [table] date <> 05/21/2014)

hope helps you.

sql sql-server-2012