Database
1.📚SQL 문법 정리
insertupdatedeleteselectcreatealterdroptruncaterenamegrantrevokecommitrollbacksavepoint테이블 생성create table student (칼럼명 타입 조건(not null 등),칼럼명 타입 조건(not
2.🌱프로그래머스 SQL 고득점 Kit [SELECT]
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 wher
3.🥑프로그래머스 SQL 고득점 Kit [SUM, MAX, MIN]
SELECT MAX(DATETIME)FROM ANIMAL_INS;SSELECT MIN(DATETIME)FROM ANIMAL_INS;SELECT COUNT(ANIMAL_ID)FROM ANIMAL_INS;SELECT COUNT(DISTINCT NAME) countFROM
4.🌻프로그래머스 SQL 고득점 Kit [GROUP BY]
SELECT ANIMAL_TYPE, COUNT(\*) countFROM ANIMAL_INSGROUP BY ANIMAL_TYPEORDER BY ANIMAL_TYPESELECT NAME, COUNT(\*) as COUNTFROM ANIMAL_INSWHERE NAME IS
5.🌼프로그래머스 SQL 고득점 Kit [IS NULL]
SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NULL;SELECT ANIMAL_IDFROM ANIMAL_INSWHERE NAME IS NOT NULL;SELECT ANIMAL_TYPE, IFNULL(NAME, "No name") AS
6.🌳프로그래머스 SQL 고득점 Kit [JOIN]
SELECT ANIMAL_OUTS.ANIMAL_ID, ANIMAL_OUTS.NAMEFROM ANIMAL_OUTS LEFT JOIN ANIMAL_INSON ANIMAL_OUTS.ANIMAL_ID = ANIMAL_INS.ANIMAL_IDWHERE ANIMAL_INS.ANI
7.🌵프로그래머스 SQL 고득점 Kit [String, Date]
SELECT ANIMAL_ID, NAME, SEX_UPON_INTAKEFROM ANIMAL_INSWHERE NAME IN("Lucy", "Ella", "Pickle", "Rogan", "Sabrina", "Mitty")ORDER BY ANIMAL_IDSELECT ANI