SESSION NAME: Data Sorting.
QUESTION NAME: Union ALL - Query Ascending.
TABLE DESCRIPTION:
The "customers" table has following field
1. customerid
2. firstname
3. lastname
4. city
5. state
The "suppliers" table has following field
1. SupplierID
2. SupplierName
3. ContactName
4. Address
5. City
6. PostalCode
7. Country
8.Phone
Write a query to display city from customers tables and suppliers table using "UNION ALL" clause.
The final resultant should be in Ascending order.
1. customerid
2. firstname
3. lastname
4. city
5. state
The "suppliers" table has following field
1. SupplierID
2. SupplierName
3. ContactName
4. Address
5. City
6. PostalCode
7. Country
8.Phone
Write a query to display city from customers tables and suppliers table using "UNION ALL" clause.
The final resultant should be in Ascending order.
CODE:
select CITY from CUSTOMERS UNION ALL select CITY from SUPPLIERS order by CITY asc;
3 Comments
It's showing error, not sure what's wrong.
ReplyDeleteOh wait had to refresh my entire page smh sorry.
DeleteIt Works 100%
Delete