country, state 2 tables r there. in table 1 have cid,cname table2 have sid,snam

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?

Question Posted / simha

3 Answers
7589 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

Answer / joe

join these two tables on cid and get all the columns to
output. Then in aggregator stage, count rows with key
collumn cid..Then use filter or transformer to get records
with count> 25

Is This Answer Correct ?

13 Yes

0 No

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

Answer / 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

country, state 2 tables r there. in table 1 have cid,cname table2 have sid,sname,cid. i want based ..

Answer / simha

same scenario i want datastage side?

Is This Answer Correct ?

0 Yes

0 No

Post New Answer