REPOST: Re: sql to find selective duplicate rows

On Thu, 24 Jan 2002 21:05:44 +0100, "lif" <t_at_i.gb> wrote:

>
>select first_name,mid_name,last_name,count(*)
>from nametab
>group by first_name,mid_name,last_name
>having count(*) =1
>
>??

I believe that mid_name should be after last_name to force GROUPing on first_name, last_name.

Of course, if he only wanted separate rows.

SELECT

	A.First_Name,
	A.Mid_Name,
	A.Last_Name
FROM
	NameTab A,
	NameTab B
WHERE
	A.First_Name = B.First_Name
  AND	A.Last_Name = B.Last_Name
  AND	A.MidName <> B.Mid_name;

Brian

• WAS CANCELLED BY =======: From: SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK (Brian Tkatch) Control: cancel <3c506e71.1429187422_at_news.alt.net> Subject: cmsg cancel <3c506e71.1429187422_at_news.alt.net> Date: Mon, 28 Jan 2002 02:06:40 GMT Message-ID: <cancel.3c506e71.1429187422_at_news.alt.net> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!cert.uni-stuttgart.de!news.belwue.de!news.uni-ulm.de!rz.uni-karlsruhe.de!blackbush.xlink.net!blackbush.de.kpnqwest.net!news-in.ivm.net!newsfeed00.sul.t-online.de!t-online.de!newsfeed.gamma.ru!Gamma.RU!news.stealth.net!msrtrans1!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40726143

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Thu Jan 24 2002 - 14:32:54 CST