Get duplicates in People Soft [message #462519] |
Thu, 24 June 2010 13:19 |
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
|
|
|