SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Findig duplicate using complex key
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kond.mohan
Posting Yak Master

India
193 Posts

Posted - 03/02/2013 :  05:43:04  Show Profile  Reply with Quote
hi,
i have table in sql sever 2008(having count is 15668050),
my table pkey is ACID+ACCT_POA_AS_SRL_NUM+BANK_ID
using this key i want to know the duplicate valuse in the table
i have tried few queries. but i didn't get the solution.-
---
SELECT ACID+ACCT_POA_AS_SRL_NUM+BANK_ID, COUNT(*) TotalCount
FROM abc GROUP BY ACID+ACCT_POA_AS_SRL_NUM+BANK_ID
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC
----------

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 03/02/2013 :  06:25:13  Show Profile  Reply with Quote

SELECT ACID,ACCT_POA_AS_SRL_NUM,BANK_ID, COUNT(*) TotalCount
FROM abc GROUP BY ACID,ACCT_POA_AS_SRL_NUM,BANK_ID
HAVING COUNT(*) > 1
ORDER BY COUNT(*) DESC


if you've pk set via constraint, it will never have duplicate values

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000