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 |
|
dturner
Starting Member
24 Posts |
 Posted - 2005-12-14 : 00:53:15
|
| Hello all and I am happy to have joined the forum.Got a questionI am trying to select records from a table which have seen a VW Bug >= 5 times in one dayMy table hold information such asDateseenpersonidemailnameWhat is the best way to select this information?Thank you |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-14 : 00:58:20
|
This is the Forum to contribute workable scripts. Hereafter post your questions at Developer Forum  Post some sample data and the result you wantMadhivananFailing to plan is Planning to fail |
 |
|
|
dturner
Starting Member
24 Posts |
Posted - 2005-12-14 : 01:13:47
|
| Madhivanan Thank you,OkSo table has such data as 2001-05-05 15:23:27.453 ME@yahoo.com Joe 41122000-12-22 08:11:12.857 notME@yahoo.com Mikey 2352000-05-05 16:21:37.497 ME@yahoo.com Joe 41122000-10-02 16:21:05.030 notyou@yahoo.com Johnson 222221998-12-18 08:46:06.900 she@yahoo.com Elliot 12001-05-05 12:41:37.587 ME@yahoo.com Joe 41122001-02-11 20:36:08.520 him@yahoo.com Tim 342552001-05-05 05:29:16.800 ME@yahoo.com Joe 41122001-10-05 10:58:07.310 earth@eartlink.net sue 232322001-05-05 18:59:12.427 ME@yahoo.com Joe 4112This is what I would want returned:Name email Count Joe ME@yahoo.com 5 |
|
|
|
dturner
Starting Member
24 Posts |
Posted - 2005-12-14 : 01:35:04
|
| CloseReposted at DeveloperThe world has more information to offer than I can hold in my head |
|
|
|
|
|
|
Select statement