Experts,
Looking at the data set below, if I need to sort first by fruit_type and then by country I would use the following sql: "SELECT * FROM MYTABLE ORDER BY fruit_type, country"
However, in this particular data set, it is sorted by fruit type but it is not in ASC or DESC order. Is there a way I can write a query to sort by fruit type using the specific fruit names? The table is a MSDE sql database.
Sample data set:
fruit_type,country
Banana, Canada
Banana, Canada
Banana, US
Banana, US
Apple, Canada
Apple, US
Orange, Canada
Orange, Canada
Orange, US
Orange, US
Orange, US
Start Free Trial
