๐Ÿ“Certificate/Engineer Information Processing

[์ •๋ณด์ฒ˜๋ฆฌ๊ธฐ์‚ฌ] ์‹ค๊ธฐ ํ”„๋กœ๊ทธ๋ž˜๋ฐ์–ธ์–ด 3๋ฌธ์ œ (13)

Sun A 2024. 10. 1. 13:48

1๏ธโƒฃ [C์–ธ์–ด]

2022.2ํšŒ

๋‹ค์Œ ์†Œ์Šค์ฝ”๋“œ์— ๋Œ€ํ•œ ์ถœ๋ ฅ๊ฐ’์„ ์ž‘์„ฑํ•˜์‹œ์˜ค.

#include <stdio.h>
struct A{
   int n, g;
};

int main(){
   struct A array[2];
   
   for(int i=0; i<2; i++){
       array[i].n = i;
       array[i].g = i + 1;
   }
   
   printf("%d", array[0].n + array[1].g);
   return 0;
}
2
a[0].n 0
a[0].g 1
a[1].n 1
a[1].g 2

 

2๏ธโƒฃ [SQL]

2020.3ํšŒ

ํ•™์ƒ ํ…Œ์ด๋ธ”์—์„œ ์ด๋ฆ„์ด ๋ฏผ์ˆ˜์ธ ํŠœํ”Œ์„ ์‚ญ์ œํ•˜๋Š” SQL๋ฌธ์„ ์ž‘์„ฑํ•˜์‹œ์˜ค

[ํ•™์ƒ]

ํ•™๋ฒˆ ์ด๋ฆ„ ์ ์ˆ˜ ๊ณผ๋ชฉ์ด๋ฆ„
1000 ๊น€์ •๋ฏธ 90 ์•Œ๊ณ ๋ฆฌ์ฆ˜
2000 ๊ฐ•์€๋ฏธ 95 ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค
3000 ํ™๊ธธ๋™ 90 ์ „์‚ฐ์ˆ˜ํ•™
4000 ๋ฏผ์ˆ˜ 95 ์šด์˜์ฒด์ œ
DELETE 
FROM ํ•™์ƒ
WHRER ์ด๋ฆ„ = '๋ฏผ์ˆ˜';

 

3๏ธโƒฃ [Python]

2023.2

๋‹ค์Œ Python ์ฝ”๋“œ์— ์•Œ๋งž๋Š” ์ถœ๋ ฅ๊ฐ’์„ ์ž‘์„ฑํ•˜์‹œ์˜ค.

a = "engineer information processing"
b = a[:3]
c = a[4:6]
d = a[28:]
e = b+c+d
print(e)

 

engneing

b๋Š” 0๋ถ€ํ„ฐ 2 ์ธ๋ฑ์Šค ๊ฐ’ ์ถœ๋ ฅ

b = eng

c๋Š” 4, 5 ์ธ๋ฑ์Šค ๊ฐ’ ์ถœ๋ ฅ

c = ne

d = 28 ์ธ๋ฑ์Šค๋ถ€ํ„ฐ ๋๊นŒ์ง€ ์ถœ๋ ฅ

d = ing

e = engmeing