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 next 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

Re: Repeated rows - how use People Soft [message #462524 is a reply to message #462519] Thu, 24 June 2010 13:44 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Are both SEARCH on this forum & GOOGLE broken for you?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Repeated rows - how use People Soft [message #462525 is a reply to message #462519] Thu, 24 June 2010 13:44 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
What kind of problems? Your SQL synatx seems OK:

SQL> select  count(*),job
  2    from  emp
  3    having count(*) > 1 group by job
  4  /

  COUNT(*) JOB
---------- ---------
         4 CLERK
         4 SALESMAN
         3 MANAGER
         2 ANALYST

SQL> 


SY.
Re: Repeated rows - how use People Soft [message #462536 is a reply to message #462525] Thu, 24 June 2010 15:32 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I think it is not that this very SQL statement won't work in SQL*Plus. @new_user_oracle can't write the similar statement in PeopleSoft (which, I presume, has a different syntax) (also, note that I have never even seen PeopleSoft so - maybe I'm wrong).
Previous Topic: Choosing platform
Next Topic: Research into large ERP systems for less large orgs and Outsourcing
Goto Forum:
  


Current Time: Thu Mar 28 17:14:17 CDT 2024