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
- 8919 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 is data partitioning?
Define orabulk and bcp stages?
What are datastage sequences?
Hi, what is use of Macros,functions and Routines..? At what situation you are used. If you know the answer please explain it. Thanks.
What are the partitioning techniques available in link partitioner?
What is the use of datastage director?
How a server job can be converted to a parallel job?
What are the steps required to kill the job in Datastage?
Have you have ever worked in unix environment and why it is useful in datastage?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
sed,awk,head
Explain the importance of surrogate key in data warehousing?
How many areas for files does datastage have?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What is the importance of the exception activity in datastage?
