Interested to Buy Any Domain ? << Click Here >> for more details...
I have two tables :
COuntry,city
I want all the cities in each country.Question on Cross Join.
- 3 Answers
- 6381 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / saiki
SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME
FROM COUNTRY,CITY
WHERE COUNTRY.COUNTRY_NAME = CITY.COUNTRY_NAME
GROUP BY COUNTRY.COUNTRY_NAME;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to view existing locks on the database?
How to rename a tablespace in oracle?
Explain oracle data types with examples?
What are the different types of record groups in oracle? Explain each of them
What is meant by joins?
Explain the use of indexes option in exp command.
How to invoke the data pump export utility?
How to display employee records who gets more salary than the average salary in the department?
How to load a large xml file?
What is the recommended interval at which to run statspack snapshots, and why?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
What is an oracle data file?
Explain the difference between a procedure and a function?
How much memory your 10g xe server is using?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
