๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
728x90
๋ฐ˜์‘ํ˜•

์•Œ๊ณ ๋ฆฌ์ฆ˜ ๐Ÿ’ก/ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค25

์ด๋ฆ„์ด ์—†๋Š” ๋™๋ฌผ์˜ ์•„์ด๋”” / is null is null -- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š” SELECT ANIMAL_ID from animal_ins where name is null order by ANIMAL_ID asc 2023. 11. 3.
์ด๋ฆ„์ด ์žˆ๋Š” ๋™๋ฌผ์˜ ์•„์ด๋”” IS NOT NULL -- ์ฝ”๋“œ๋ฅผ ์ž…๋ ฅํ•˜์„ธ์š” SELECT ANIMAL_ID from ANIMAL_INS where NAME IS NOT NULL order by ANIMAL_ID asc 2023. 11. 3.
2023 KAKAO BLIND RECRUITMENT 1.๊ฐœ์ธ ์ •๋ณด ์ˆ˜์ง‘ ์œ ํšจ๊ธฐ๊ฐ„ https://school.programmers.co.kr/learn/courses/30/lessons/150370 ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค ์ฝ”๋“œ ์ค‘์‹ฌ์˜ ๊ฐœ๋ฐœ์ž ์ฑ„์šฉ. ์Šคํƒ ๊ธฐ๋ฐ˜์˜ ํฌ์ง€์…˜ ๋งค์นญ. ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค์˜ ๊ฐœ๋ฐœ์ž ๋งž์ถคํ˜• ํ”„๋กœํ•„์„ ๋“ฑ๋กํ•˜๊ณ , ๋‚˜์™€ ๊ธฐ์ˆ  ๊ถํ•ฉ์ด ์ž˜ ๋งž๋Š” ๊ธฐ์—…๋“ค์„ ๋งค์นญ ๋ฐ›์œผ์„ธ์š”. programmers.co.kr def dateToDay(date): year, month, day = map(int, date.split(".")) return (year * 12 * 28) + (month * 28) + day def solution(today, terms, privacies): answer = [] # today today = dateToDay(today) # terms ter.. 2023. 9. 7.
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค_์™„์ „ํƒ์ƒ‰] ์†Œ์ˆ˜ ์ฐพ๊ธฐ(ํŒŒ์ด์ฌ) ๋ฌธ์ œ ํ’€๊ธฐ ์ „ ์•Œ์•„์•ผ ๋  ์ง€์‹ - ์ˆœ์—ด(permutations) ์„œ๋กœ ๋‹ค๋ฅธ n๊ฐœ์—์„œ r๊ฐœ๋ฅผ ์„ ํƒํ• ๋•Œ ์ˆœ์„œ๋ฅผ ๊ณ ๋ คํ•˜์—ฌ ์ค‘๋ณต์—†์ด ๋ฝ‘์„ ๊ฒฝ์šฐ์˜ ์ˆ˜. ํŒŒ์ด์ฌ์—๋Š” ์ˆœ์—ด(permutations)์™€ ์กฐํ•ฉ ์„ ์†์‰ฝ๊ฒŒ ๋งŒ๋“ค์–ด์ฃผ๋Š” ๋ชจ๋“ˆ iteratools๊ฐ€ ์žˆ๋‹ค. ๊ทธ๋ž˜์„œ from iteratools import permutations ์œ„ ์ฝ”๋“œ๋ฅผ ์ด์šฉํ•˜์—ฌ ๋ชจ๋“ˆ์„ ๊ฐ€์ ธ์˜ค๋ฉด ๋œ๋‹ค. ์˜ˆ์‹œ ์ฝ”๋“œ from iteratools import permutations # ์ˆœ์—ด๊ณผ ์กฐํ•ฉ์„ ์†์‰ฝ๊ฒŒ ๋งŒ๋“ค์–ด์ฃผ๋Š” ๋ชจ๋“ˆ itertools ์‚ฌ์šฉ arr = ['a','b','c','d'] # ์˜ˆ์‹œ๋กœ ๋ฐฐ์—ด ์„ค์ •ํ•˜์—ฌ arr ๋ณ€์ˆ˜ ์ €์žฅ print(permutations(arr,2)) # ๋ฐ˜๋ณต๊ฐ€๋Šฅํ•œ ๊ฐ์ฒด(๋ฆฌ์ŠคํŠธ,ํŠœํ”Œ,๋ฌธ์ž์—ด)์•ˆ์—์„œ r๊ฐœ๋ฅผ ์„ ํƒํ•œ๋‹ค. ์—ฌ๊ธฐ์„œ r์€ .. 2022. 12. 21.
728x90
๋ฐ˜์‘ํ˜•