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
- 6481 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 |
26. Display the earliest shipping date in the format: DD/MON/YYYY
What is the order of defining local variables and sub procedures/functions?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
How to create a new view in oracle?
What is rich query?
Query to retrieve record for a many to many relationship ?
How to omit columns with default values in insert statement in oracle?
How to count duplicated values in a column in oracle?
what is the syntax of DELETE command?
various types of hints and their usage
What is the database name in oracle?
Differentiate between TRUNCATE and DELETE?
Oracle General 
