Search IT Knowledge Exchange
Join / Login
IT Knowledge Exchange
a TechTarget Expert Community
Questions & Answers
Discussions
Blogs
Tags
Welcome to TechTarget's expert community for technology professionals.
Get Access
Questions & Answers
?
Ask a question, help others, and get answers from the community
Discussions
Start a thread and discuss today's topics with top experts
Blogs
Read the latest tech blogs written by experienced community members
https://itknowledgeexchange.techtarget.com/itanswers/sql-query-18#question_answer
SQL Query
RamvishakRamesh
2505 pts.
Tags:
Thanks! We'll email you
when relevant content is
added and updated.
Following
Follow
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
Related Questions
Unified Communication Mobility System
SAP R/3 AP-Create vendors, post with forms, AP reporting
moving email to new email account
Who created this fake Facebook account of me?
Exchange 2003
0
Answer Wiki
Thanks. We'll let you know when a new response is added.
Please enter an answer.
Send me notifications when members answer or reply to this question.
Register Here
or
login
if you are already a member
E-mail
User Name
Password
Forgot Password?
I agree to TechTarget's
Terms of Use
,
Privacy Policy
, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
I agree to my information being processed by TechTarget and its
Partners
to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Answer
Answer
Processing your response...
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.
Please enter a reply.
Send me notifications when members answer or reply to this question.
Register Here
or
login
if you are already a member
E-mail
User Name
Password
Forgot Password?
I agree to TechTarget's
Terms of Use
,
Privacy Policy
, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
I agree to my information being processed by TechTarget and its
Partners
to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Reply
Processing your reply...
Sort by:
Oldest
Newest
Sorting replies...
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 points
Badges:
report
RamvishakRamesh
Oct 26, 2012 6:31 AM GMT
v5r4. This is a one time query which I can put in STRSQL
2,505 points
Badges:
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 points
Badges:
report
RamvishakRamesh
Oct 26, 2012 11:53 AM GMT
:) got it..
2,505 points
Badges:
report
BigKat
Oct 26, 2012 2:51 PM GMT
glad I could help point you in the right direction BigKat
9,460 points
Badges:
report
Next
View All Replies
ADD YOUR REPLY
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.
Register Here
or
login
if you are already a member
E-mail
User Name
Password
Forgot Password?
I agree to TechTarget's
Terms of Use
,
Privacy Policy
, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
I agree to my information being processed by TechTarget and its
Partners
to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Reply
Processing your reply...
Ask a Question
Question Title:
(150 char. limit.)
Question:
(Please be specific.)
Tags:
(Separate with commas.)
What is a Tag?
Ask Question
Featured Questions
CLIENT MAC ADDR 00 16 35 66… GUID: 0EF0C… error on startup
Asked by: Frajan
Compiling CL Program
Asked by: GHENDER
Integer value using physical file in iSeries
Asked by: hbrooks
Forgot Password
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
E-mail:
Submit
Your password has been sent to:
cguarrera@techtarget.com
To follow this tag...
There was an error processing your information. Please try again later.
Register Here
or
login
if you are already a member
E-mail
User Name
Password
Forgot Password?
I agree to TechTarget's
Terms of Use
,
Privacy Policy
, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
I agree to my information being processed by TechTarget and its
Partners
to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Follow
Thanks! We'll email you when relevant content is added and updated.
Following
Share this item with your network:
Discuss This Question: 5  Replies