Get more records that appear more than once
- by milo2010
How can I see all the records that appear more than once per day?
I have this table:
ID Name Date
1 John 27.03.2010 18:17:00
2 Mike 27.03.2010 16:38:00
3 Sonny 28.03.2010 20:23:00
4 Anna 29.03.2010 13:51:00
5 Maria 29.03.2010 21:59:00
6 Penny 29.03.2010 17:25:00
7 Alba 30.03.2010 09:36:00
8 Huston 31.03.2010 10:19:00
I wanna get:
1 John 27.03.2010 18:17:00
2 Mike 27.03.2010 16:38:00
4 Anna 29.03.2010 13:51:00
5 Maria 29.03.2010 21:59:00
6 Penny 29.03.2010 17:25:00