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!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. sqlsnip

    Finding Duplicates In Table

    Great - works perfectly, thanks! I wasnt aware that you could use both WHERE and HAVING in the same query. Noob mistake. Thanks all
  2. sqlsnip

    Finding Duplicates In Table

    Here's one I have tried: SELECT tblInvoice.ClaimID, COUNT(tblInvoice.InvoiceID) AS TOTAL_INVOICES FROM tblInvoice GROUP BY tblInvoice.ClaimID HAVING COUNT(tblInvoice.InvoiceID) > 1 AND tblInvoice.IsPartial = 'TRUE' I get the following error, which I understand but I can't figure out where...
  3. sqlsnip

    Finding Duplicates In Table

    I have had a go myself using the GROUP BY and HAVING clause but no cigar. I will paste in a copy of what I have tried so far tomorrow for you to take a look at. Thanks
  4. sqlsnip

    Finding Duplicates In Table

    Hi All! I’m sure this will be a very basic piece of sql for most of you. I am just starting out in the world of development and have come across a problem that I need help with. Basically, I have one table ( tblInvoice ) and I need to find duplicates within. The tblInvoice has three...

Part and Inventory Search

Back
Top