- Data Sorting Customers - FIRST NAME.
- DISTINCT - From CITY Table - Ascending.
- Data Sorting Customers - FIRST NAME DESCENDING.
- Data Sorting Customers - STATE ORDER.
- DISTINCT - From CITY Table - Descending.
- Union ALL - Query Descending.
- DISTINCT - From CITY Table -Descending.
- Union ALL - Query Ascending.
- Data Sorting Suppliers.
3 Comments
Drop your telegram maybe?
ReplyDeleteDISCORD ID: Nightwalker#6233
DeleteSESSION NAME:Data Sorting
ReplyDeleteQUESTION 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
Answer:
select distinct countrycode from city;