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
- 9067 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
How will you move hashed file from one location to another location?
What is apt_config in datastage?
What are the primary usages of datastage tool?
Can you highlight the main features of ibm infosphere information server?
Where do you see different stages in the designer?
What is ibm datastage?
What is the use of datastage designer?
how can we validate the flat files using the date in the header and number of records in the flat file? Using both conditions at a time.
Describe the architecture of datastage?
What all the types of jobs you developed?
How many types of sorting methods are available in datastage?
Can you filter data in hashed file?
What is the process of killing a job in datastage?
What are the types of containers?
Can you explain kafka connector?
