SESSION NAME: Data Sorting.
QUESTION NAME: DISTINCT - From CITY Table.
TABLE DESCRIPTION:
The "city" table consists of following fields:
1.ID
2. NAME
3. COUNTRYCODE
4. DISTRICT
5. POPULATION
Write a query to display the distinct "COUNTRYCODE"
from city table
1.ID
2. NAME
3. COUNTRYCODE
4. DISTRICT
5. POPULATION
Write a query to display the distinct "COUNTRYCODE"
from city table
CODE:
select distinct countrycode from city;
0 Comments