OraFAQ Forum: PeopleSoft, JD Edwards & Siebel » Get duplicates in People Soft

Home » Applications » PeopleSoft, JD Edwards & Siebel » Get duplicates in People Soft (People Soft)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Re: Repeated rows - how use People Soft [message #462524 is a reply to message #462519]

Thu, 24 June 2010 13:44

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/

Report message to a moderator

Re: Repeated rows - how use People Soft [message #462525 is a reply to message #462519]

Thu, 24 June 2010 13:44

Solomon Yakobson
Messages: 3303
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.

Report message to a moderator

Re: Repeated rows - how use People Soft [message #462536 is a reply to message #462525]

Thu, 24 June 2010 15:32

Littlefoot
Messages: 21823
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).

Report message to a moderator

Previous Topic:	Choosing platform
Next Topic:	Research into large ERP systems for less large orgs and Outsourcing

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 23 21:50:00 CST 2025