SESSION NAME: Data Sorting.
QUESTION NAME: Data Sorting Customers - STATE ORDER.
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 STATE 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 STATE filed in ascending order
CODE:
select * from customers order by state;
0 Comments