Oracle Open World PeopleSoft

109 members

Description

Oracle Open World group is designed to focus consultants and knowledge discussions for integrated PeopleSoft consulting - sharing PeopleSoft jobs connecting all in PeopleSoft community

Comments Discussions Members

SQL to find duplicates - Sample PS_PERS_NID

by Maryln Geyer

Feb 7, 2014

Here is a sample SQL of how one could find multiple rows.

Example: Using HAVING count(*) > 1

SELECT A.EMPLID,
COUNT(A.EMPLID) AS NumOccurrences
FROM PS_PERS_NID A
GROUP BY A.EMPLID
HAVING ( COUNT(A.EMPLID) > 1 )

Read further:

http://jmcmahon33.blogspot.com/2012/03/sql-to-find-duplicates-sampl...