[ABAP] AT FIRST / AT LAST / AT NEW / AT END OF / ON CHANGE OF

COL1(1) TYPE C COL2(3) TYPE C COL3 TYPE I COL4(3) TYPE C A 001 10 aaa A 001 30 aaa A 001 20 aab B 002 0 bbb B 002 50 bbb A 002 50 aaa μœ„μ™€ 같은 μΈν„°λ„ν…Œμ΄λΈ” lt_tab, 슀트럭쳐 ls_tab 을 λ§Œλ“€μ—ˆλ‹€κ³  ν•  λ•Œ, 🌝 AT FIRST /... Continue reading...

[SQL] ROLLUP ν•¨μˆ˜

πŸ‘Š μ†Œκ·Έλ£Ή κ°„μ˜ μ†Œκ³„(SUBTOTAL)와 합계(GRAND TOTAL)λ₯Ό κ³„μ‚°ν•˜λŠ” ROLLUP ν•¨μˆ˜μ— λŒ€ν•΄ μ•Œμ•„λ³΄μž πŸ‘Š β–Ά DEPT β–Ά EMP GROUP BY 절 μ‚¬μš© SELECT B.DNAME, A.JOB, COUNT(*) AS EMP_CNT, SUM(A.SAL) AS SAL_SUM FROM EMP A, DEPT B WHERE B.DEPTNO = A.DEPTNO GROUP BY B.DNAME, A.JOB; μ‹€ν–‰κ²°κ³Ό ) GROUP BY 절 + ORDER BY... Continue reading...

push, unshift, splice / pop, shift, splice

push / pop push λ°°μ—΄μ˜ λ§ˆμ§€λ§‰μ— μš”μ†Œ μΆ”κ°€ var array = ['bonjour', 'baguette', 'croissant']; array.push('frites'); console.log(array); console.log(array[3]); // (4)Β ['bonjour', 'baguette', 'croissant', 'frites'] // frites pop λ°°μ—΄μ˜ λ§ˆμ§€λ§‰ μš”μ†Œ 제거 var array = ['bonjour', 'baguette', 'croissant']; array.pop(); console.log(array); // (2)Β ['bonjour', 'baguette'] uhshift / shift unshift λ°°μ—΄μ˜ 맨 μ•žμ— μƒˆλ‘œμš΄ μš”μ†Œ μΆ”κ°€... Continue reading...

some() / every()

every() λ°°μ—΄μ˜ λͺ¨λ“  μš”μ†Œκ°€ 주어진 쑰건에 ν•΄λ‹Ήν•˜λŠ”μ§€ 확인 λͺ¨λ‘ ν•΄λ‹Ήλ˜λ©΄ true, 그렇지 μ•ŠμœΌλ©΄ false 리턴 ex) var array = ['10', '20', '30']; function num(element) { var num = (element % 10 == 0); return num; }; var rslt = array.every(num); console.log(rslt); // true some() λ°°μ—΄ 쀑 ν•˜λ‚˜μ˜ μš”μ†ŒλΌλ„ 주어진 쑰건에... Continue reading...

.includes() / .indexOf()

πŸ“‘ μžλ°”μŠ€ν¬λ¦½νŠΈ Array / Array Method .includes() λ¬Έμžμ—΄μ΄ νŠΉμ • λ¬Έμžμ—΄μ„ ν¬ν•¨ν•˜λŠ”μ§€ ν™•μΈν•˜λŠ” λ©”μ„œλ“œ μ‘΄μž¬ν•˜λ©΄ true, μ‘΄μž¬ν•˜μ§€ μ•ŠμœΌλ©΄ false 리턴 includes(searchElement) includes(searchElement, n) : n번째 μΈλ±μŠ€λΆ€ν„° 검색 ex) var array = [1, 30, 23, 11]; console.log(array.includes(23)); //true console.log(array.includes(2)); //false var strArray = ['red', 'blue', 'green', 'black']; console.log(strArray.includes('blue', 1)); //true console.log(strArray.includes('blue', 2));... Continue reading...