Find Duplicate Data

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 [mailto:Travis@xxxxxxxxxxxxxxxxxxxxxxxxx]
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

.