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
- 6382 Views
- Microsoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / u.radha
SELECT COUNTRY.COUNTRY_NAME,CITY.CITY_NAME FROM COUNTRY,CITY
WHERE COUNTRY.COUNTRY_NAME = CITY.COUNTRY_NAME ;
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / 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 |
Answer / cheeku
select A.cities,B.countries
from A,B;
where Table A has col cities
where Table B has col countries
| Is This Answer Correct ? | 3 Yes | 5 No |
1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.
What is the difference between RBBMS & DBMS?
What is the database name in oracle?
a query to select maxmun 3 salaries of employee table
IS it possible to built the oracle database without setting the kernal parameters?
What is dynamic proxy?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How to list all user accounts in oracle?
What is the difference between truncate & delete command?
How to convert a string to a date in oracle database?
Please explain compound trigger in oracle?
What are the restrictions in a oracle read only transaction?
Oracle General 
