Interested to Buy Any Domain ? << Click Here >> for more details...
country, state 2 tables r there. in table 1 have cid,cname
table2 have sid,sname,cid. i want based on cid which country's
having more than 25 states i want to display?
- 3 Answers
- 9011 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / manikanta.srinu
select state.cid,country.cname from country inner join
state on country.cid=state.cid group by
state.cid,country.cname having count(state.sname)>25
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What are the different common services in datastage?
How can we improve performance of data stage jobs?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What is ds designer?
How do you remove duplicate values in datastage?
What are transforms and what is the differenece between routines and transforms?
What are the different type of jobs in datastage?
Differentiate between Symmetric Multiprocessing and Massive Parallel Processing?
How do you generate sequence number in datastage?
how can we create rank using datastage?what is the meaning of rank?
What are the job parameters?
how to read 100 records at a time in source a) hw is it fr metadata Same and b) if metadata is nt same?
Can you explain players in datastage?
Explain ibm infosphere information server and highlight its main features?
