2020/12

    [MYSQL] SELECT sum,max,min FROM Programmers

    [MYSQL] SELECT sum,max,min FROM Programmers

    SELECT MAX(DATETIME) FROM ANIMAL_INS; SELECT MIN(DATETIME) FROM ANIMAL_INS; SELECT COUNT(*) AS 'COUNT' FROM ANIMAL_INS; COUNT -갯 수 return하는 쿼리 AS -보여줄 칼럼이름 지정 SELECT COUNT(DISTINCT NAME) AS 'COUNT' FROM ANIMAL_INS WHERE NAME IS NOT NULL; DISTINCT - 중복을 제거하는 쿼리

    [MYSQL] SELECT select FROM Programmers

    [MYSQL] SELECT select FROM Programmers

    SELECT * FROM ANIMAL_INS ORDER BY ANIMAL_ID; SELECT NAME, DATETIME FROM ANIMAL_INS ORDER BY ANIMAL_ID DESC; SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION = 'Sick'; SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE NOT INTAKE_CONDITION = 'Aged'; SELECT ANIMAL_ID, NAME FROM ANIMAL_INS ORDER BY ANIMAL_ID; SELECT ANIMAL_ID, NAME, DATETIME FROM ANIMAL_INS ORDER BY NAME, DATETIME DESC; SELE..