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
- 9170 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 the difference between validated and compiled in the datastage?
How to manage date conversion in Datastage?
What are the steps required to kill the job in Datastage?
Enlist various types of routines in datastage.
What are datastage sequences?
What is the roundrobin collector?
On which Dimension Table you implemented SCD Type in your Project
Which algorithm you used for your hashfile?
In work load management there are three options of Low priority, Medium priority and High Priority Jobs which can be used for resource management. why this feature is developed when there is already jobs prescheduled by scheduler or autosys. what will be the use of workload management then?
What is a merge?
Can you define merge?
What is the difference between in process and inter process?
What is the difference between datastage and datastage tx?
how to sort two columns in single job in datastage.
What are the benefits of datastage?
