SESSION NAME: Data Sorting.
QUESTION NAME: DISTINCT - From CITY Table -Descending.
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 and the final resultant should display
country code in descending order
1.ID
2. NAME
3. COUNTRYCODE
4. DISTRICT
5. POPULATION
Write a query to display the distinct "COUNTRYCODE"
from city table and the final resultant should display
country code in descending order
CODE:
select distinct countrycode from city order by COUNTRYCODE desc;
2 Comments
Executing but not 100%
ReplyDeleteDid refresh this time.
DISTINCT - From CITY Table -Descending.
Delete2 similar questions like this
For one it's executing 100% for another, it is not.