Home » Applications » PeopleSoft, JD Edwards & Siebel » Get duplicates in People Soft (People Soft)
icon3.gif  Get duplicates in People Soft [message #462519] Thu, 24 June 2010 13:19 Go to previous message
new_user_oracle
Messages: 1
Registered: June 2010
Location: CR
Junior Member
Hi !! I am new using PeopleSoft 9.0.
And I am wondering whow could I create a sentence that retrieves all repeated names from a table.

For example the table has the following data:
PersonID - Person Name
11223 Paul Chan
11444 Paul Chan
145689 Katherine Sanders

So, I am expecting to get:
11223 Paul Chan
11444 Paul Chan

I have problems trying to create a sentence like:
SELECT COUNT(*), name
FROM table
HAVING COUNT(*)>1 GROUP BY name

[Updated on: Thu, 24 June 2010 13:25]

Report message to a moderator

 
Read Message icon3.gif
Read Message
Read Message
Read Message
Previous Topic: Choosing platform
Next Topic: Research into large ERP systems for less large orgs and Outsourcing
Goto Forum:
  


Current Time: Fri Mar 29 07:11:12 CDT 2024