Sorting in reverse order (with.MySQL)

This article is about sorting in reverse order (with.MySQL).

I want to solve the coding test problem, find out how to solve it differently from the retrospective of the problem I solved, and get to know.

Let’s get to the problem first.

Problem

Please write a SQL statement that looks up the names of all the animals that came into the animal shelter and the start date of protection.

Problem Description

The ANIMAL_INS table is a table that contains information about animals that have entered the animal shelter.

ANIMAL_INS table structures are as follows: ANIMAL_ID, ANIMAL_TYPE, DATETIME, INTAKE_CONDITION, NAME, SEX_UPON_INTAKE indicate the animal’s ID, species, start date of protection, status, name, gender, and neutralization at the start of protection, respectively.

ANIMAL_INS table

problem solving

SELECT NAME, DATETIME
FROM ANIMAL_INS
ORDER BY ANIMAL_ID DESC;

Solution Description

In the ANIMAL_INS table required in the problem, the names and start dates of protection of all animals were printed, and ANIMAL_IDs were ordered in reverse order.