개발울렁증

SELECT ARRAY['2020','2021','2022','2023'] SELECT unnest(ARRAY['2020','2021','2022','2023']) 연도별 월 조회하기 select a.year, b.month from (SELECT unnest(ARRAY['2020','2021','2022','2023']) as year) a , (select unnest(ARRAY['01','02','03','04']) as month) b

PROGRAMMING/DATABASE 2021. 9. 3. 11:04

string_to_array(문자, 패턴) 리턴타입: text[] 예시1) select string_to_array('A,B,C,D,E',',') from dual; 결과) {A,B,C,D,E} 예시2) select string_to_array('A/B/C/D/E', '/') from dual; 결과) {A,B,C,D,E}

PROGRAMMING/DATABASE 2020. 5. 25. 10:50

function f_getUniqueArray(data, groupStr){ var uniqueNames =[]; $.each(data, function(index, item){ var group = item[groupStr]; //21 if($.inArray(group, uniqueNames) === -1) uniqueNames.push(group); }) return uniqueNames; } data = Array값 groupStr 필터랑 할 데이터 ex) data = [ {name='A', date='2019'}, {name='B', date='2019'}, {name='C', date='2019'}, {name='D', date='2019'}, {name='E', date='2019'}, {na..

PROGRAMMING/JAVASCRIPT 2020. 2. 21. 16:48