SESSION NAME: Data Sorting.
QUESTION NAME: Data Sorting Suppliers.
TABLE DESCRIPTION:
The "customers" table has following field
1. customerid
2. firstname
3. lastname
4. city
5. state
Write a query to display the all the data's in the customers
table with CITY filed in ascending order
1. customerid
2. firstname
3. lastname
4. city
5. state
Write a query to display the all the data's in the customers
table with CITY filed in ascending order
CODE:
select * from customers order by city asc;
0 Comments