SESSION NAME: Data Sorting.
QUESTION NAME: Data Sorting Customers - FIRST NAME DESCENDING.
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 descending 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 descending order
CODE:
select * from CUSTOMERS order by firstname desc;
0 Comments