SQL Query

RamvishakRamesh

2505 pts.

Tags:

AS/400

I have a file which has a account number and name. I want to find all those account number which has more than one name. How will the query looks like

Software/Hardware used:
As400

Asked: October 26, 2012 5:58 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

Discuss This Question: 5 Replies

There was an error processing your information. Please try again later.

Thanks. We'll let you know when a new response is added.

Send me notifications when members answer or reply to this question.

TomLiotta Oct 26, 2012 6:28 AM GMT

There are multiple possibilities. What OS release are you working with? Capabilities change with different releases. -- Tom

125,585 pointsBadges:

report
RamvishakRamesh Oct 26, 2012 6:31 AM GMT

v5r4. This is a one time query which I can put in STRSQL

2,505 pointsBadges:

report
BigKat Oct 26, 2012 11:27 AM GMT

As this could be a homework type of question, lets start with a hint. HINT: think about using COUNT() in the select and a HAVING clause

9,460 pointsBadges:

report
RamvishakRamesh Oct 26, 2012 11:53 AM GMT

:) got it..

2,505 pointsBadges:

report
BigKat Oct 26, 2012 2:51 PM GMT

glad I could help point you in the right direction BigKat

9,460 pointsBadges:

report