Top n records (with.MySQL)

This article examines the top n records (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 name of the first animal to enter the animal shelter.

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

NAME	TYPE	NULLABLE
ANIMAL_ID	VARCHAR(N)	FALSE
ANIMAL_TYPE	VARCHAR(N)	FALSE
DATETIME	DATETIME	FALSE
INTAKE_CONDITION	VARCHAR(N)	FALSE
NAME	VARCHAR(N)	TRUE
SEX_UPON_INTAKE	VARCHAR(N)	FALSE

problem solving

SELECT NAME
FROM ANIMAL_INS
ORDER BY DATETIME LIMIT 1;

Solution Description

In the ANIMAL_INS table required in the problem, only one line was printed using LIMIT to name the first animal that came in.