MS SQL Server MSEQ - Find Duplicate Data

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Find Duplicate Data

Tony Sebion

2005-08-03, 1:25 pm

This query worked for me:

SELECT Full_Name,FLT_ID, FLT_DT_ID,PNR_ID
FROM TABLE
GROUP BY Full_Name,FLT_ID, FLT_DT_ID,PNR_ID
HAVING (COUNT(*) > 1)

Good luck,
Tony Sebion

-----Original Message-----
From: Travis & #91;mailto:Travis@di
scussions.microsoft.com]=20
Posted At: Wednesday, August 03, 2005 2:31 AM
Posted To: mseq
Conversation: Find Duplicate Data
Subject: Find Duplicate Data

Hi ,

Can someone help me to build a query base on :
SELECT Full_Name,FLT_ID, FLT_DT_ID,PNR_ID

Where Full_Name,FLT_ID, FLT_DT_ID is duplicate in the same table

Thank You very much
--
Travis Tan

Sponsored Links