SQL15 2] 프로그래머스 상위 n개 레코드 SELECT NAME FROM ANIMAL_INS ORDER BY DATETIME LIMIT 1; SQL SELECT TOP, LIMIT, ROWNUM SQL TOP, LIMIT or ROWNUM Clause The SQL SELECT TOP Clause The SELECT TOP clause is used to specify the number of records to return. The SELECT TOP clause is useful on large tables with thousands of records. Returning a large number of records can impact pe www.w3schools.com 2020. 11. 2. 1] 프로그래머스 여러 기준으로 정렬하기 programmers.co.kr/learn/courses/30/lessons/59404 SELECT ANIMAL_ID, NAME,DATETIME FROM ANIMAL_INS ORDER BY NAME, DATETIME DESC; 2020. 11. 2. 0] 프로그래머스 어린 동물 찾기 SELECT ANIMAL_ID, NAME FROM ANIMAL_INS WHERE INTAKE_CONDITION != 'Aged' ORDER BY ANIMAL_ID; 2020. 11. 2. 이전 1 2 3 4 다음
