Code: Select all
SELECT name, species, birth FROM pet ORDER BY species, birth DESCI want to be able to sort by one field, but showing a specific result from that field, then another.
For example: if Species had CAT, DOG, HUMAN in it, I want to show the products in order, but first show all HUMAN, then CAT and then DOG.
Is this simple?