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
- 6586 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 |
what is the syntax of CREATE command?
20. Using a set operator, display the client number of all clients who have never placed an order.
How many types of tables supported by oracle?
How to assign values to data fields in record variables?
What is a schema in oracle?
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
How oracle handles dead locks?
How to join two tables in a single query using oracle?
How to convert a string to a date in oracle database?
How to convert numbers to characters in oracle?
What is a table index in oracle?
What does a Control file Contain ?
Oracle General 
