모든 레코드 조회하기
https://school.programmers.co.kr/learn/courses/30/lessons/59034 문제 풀이 SELECT * FROM ANIMAL_INS ORDER BY ANIMAL_ID; 실행 결과
https://school.programmers.co.kr/learn/courses/30/lessons/59034 문제 풀이 SELECT * FROM ANIMAL_INS ORDER BY ANIMAL_ID; 실행 결과
https://school.programmers.co.kr/learn/courses/30/lessons/132201 문제 풀이 SELECT PT_NAME, PT_NO, GEND_CD, AGE, CASE WHEN TLNO IS NULL THEN 'NONE' ELSE...
https://school.programmers.co.kr/learn/courses/30/lessons/120862 문제 풀이 음수와 양수를 적절히 활용하여 최댓값을 찾는다. import java.util.Arrays; public class Solution { public int solutio...
https://school.programmers.co.kr/learn/courses/30/lessons/181896 문제 풀이 public class Solution { public int solution(int[] num_list) { for (int i = 0; i < num_list.length; i++) {...
https://school.programmers.co.kr/learn/courses/30/lessons/181868 문제 풀이 public class Solution { public String[] solution(String my_string) { // 공백을 기준으로 문자열 나누기 ...
https://school.programmers.co.kr/learn/courses/30/lessons/120899 문제 풀이 public class Solution { public int[] solution(int[] array) { int max = Integer.MIN_VALUE; int inde...
https://school.programmers.co.kr/learn/courses/30/lessons/181875 문제 풀이 public class Solution { public String[] solution(String[] strArr) { for (int i = 0; i < strArr.length; ...
https://school.programmers.co.kr/learn/courses/30/lessons/181844 문제 풀이 import java.util.ArrayList; import java.util.HashSet; import java.util.List; import java.util.Set; public class Solut...
https://school.programmers.co.kr/learn/courses/30/lessons/131535 문제 풀이 SELECT COUNT(USER_ID) "AS USERS" FROM USER_INFO WHERE TO_CHAR(JOINED, 'YYYY') = '2021' AND AGE BETWEEN 20 AND 29; SE...
https://school.programmers.co.kr/learn/courses/30/lessons/59039 문제 풀이 SELECT ANIMAL_ID FROM ANIMAL_INS WHERE NAME IS NULL ORDER BY ANIMAL_ID ASC; 실행 결과