๐Ÿ˜Ž Today I Learned

[TIL] 22.01.21

soozkim 2022. 1. 22. 00:48

Database

  • Function
    • ๊ทธ๋ฃนํ•จ์ˆ˜ : SUM, AVG, COUNT, MAX, MIN
    • ๋‹จ์ผํ•จ์ˆ˜ : NVL, NVL2
    • HAVING
    • GROUP BY
  • SubQuery
    • ๋‹จ์ผํ–‰ ์„œ๋ธŒ์ฟผ๋ฆฌ
    • ๋‹ค์ค‘ํ–‰ ์„œ๋ธŒ์ฟผ๋ฆฌ : IN, NOT IN, ALL, ANY, EXISTS
  • ์ฃผ๋ง์— ํ•  ์ผ
    • ์„œ๋ธŒ์ฟผ๋ฆฌ ์˜ˆ์ œ
    • LocationController, EmployeeController ์ƒ์„ฑ
    • FrontController ์™„์„ฑํ•˜๊ธฐ
728x90
์ €์ž‘์žํ‘œ์‹œ (์ƒˆ์ฐฝ์—ด๋ฆผ)