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 Mike Lewis 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

Status
Not open for further replies.

jasonhuibers

Programmer
Sep 12, 2005
290
CA
I want to find duplicate dates for a specific book rental:
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top