Long running sql ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 3 Oct 2002 18:51:55 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702BDD9CB@lnewton.leeds.lfs.co.uk>

It's counting duplicates because the COUNT(*) is grouped by the fields that you want to check for duplicates on. So, if you have two rows with identical values in labno and batchid and testcode and testseq, you will see the values for each of those fields, and the count of how many rows have all of those values. :o)

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: bgt0990 [mailto:btighe_at_neometrics.com] Posted At: Thursday, October 03, 2002 6:34 PM Posted To: server
Conversation: Long running sql ?
Subject: Re: Long running sql ?

This is very nifty, I'm still trying to figure out how it's counting dups

bgt Received on Thu Oct 03 2002 - 12:51:55 CDT