SESSION NAME: Data Sorting.
QUESTION NAME: Data Sorting Customers - FIRST NAME.
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 FIRSTNAME 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 FIRSTNAME filed in ASCENDING order
CODE:
select * from customers order by firstname asc;
0 Comments