SESSION NAME: Data Sorting.
QUESTION NAME: DISTINCT - From CITY Table - Ascending.
TABLE DESCRIPTION:
The "city" table consists of following fields:
1.ID
2. NAME
3. COUNTRYCODE
4. DISTRICT
5. POPULATION
Write a query to display all the data from city table and
display the population column in ascending order.
1.ID
2. NAME
3. COUNTRYCODE
4. DISTRICT
5. POPULATION
Write a query to display all the data from city table and
display the population column in ascending order.
CODE:
select * from city order by population;
0 Comments