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?
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
Can you explain link buffering?
On which Dimension Table you implemented SCD Type in your Project
What is quality stage?
Why do we use exception activity in Datastage?
Field,NVL,INDEX,REPLACE,TRANSLATE,COLESC
Where do the datastage jobs get stored?
How to reverse the string using SQL?
What is the difference between orabulk and bcp stages?
how to abort the job its matain duplicates?
How to implement complex jobs in data stage?
What is the difference between in process and inter process?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are the different options associated with dsjob command?
Describe the main features of datastage?
Is possible to create skid in dim,fact tables?