jasonhuibers
Programmer
I want to find duplicate dates for a specific book rental:
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Find Duplicates - query 1
- Thread starter jasonhuibers
- Start date
- Status
-
1
- #2
SkipVought
Programmer
Select BookName, RentalDate, Count(*)
...
Having Count(*)>1
...
Having Count(*)>1
Olaf Doschke
Programmer
The colon indicates you had more to say...
To add to SkipVought:
Adding a GROUP BY BookName, RentalDate would make Count(*) count records with same BookName and RentalDate.
If you have a RentalDateTime field and store date and time you'd very seldom get a rental in the same split second, so you'd select and group by BookName, CAST(RentalDateTime as Date).
Bye, Olaf.
To add to SkipVought:
Adding a GROUP BY BookName, RentalDate would make Count(*) count records with same BookName and RentalDate.
If you have a RentalDateTime field and store date and time you'd very seldom get a rental in the same split second, so you'd select and group by BookName, CAST(RentalDateTime as Date).
Bye, Olaf.
- Status
Similar threads
- Locked
- Question