MySQL 20λ²μ§Έμμ
βΆ GROUP BYμ HAVING ββ 1. μ΄μ κ·Έλ£Ήνβ β μμ 11-1) STUDENT ν
μ΄λΈμ μλ νμμ μ
νλ
λλ³ κ·Έλ£Ήμ μΆλ ₯νλΌ. A) mysql> select substring(stu_no, 1, 4) -> from student -> group by substring(stu_no, 1, 4); β β μμ 11-2) κ° μ
νλ
λλ³ μ΄ νμ μλ₯Ό μΆλ ₯νλΌ. A) mysql> select substring(stu_no, 1, 4), count(*) -> from student -> group by substring(stu_no, 1, 4); β β μμ 11-3) λ±λ‘ν νμμ λνμ¬ νλ², λ±λ‘νμ, κ° νμμ΄ λ°μ μ₯νκΈμ μ 체 ν©μ μΆλ ₯νλΌ. A) mysql> select stu_no,..
2021. 2. 9.
MySQL 19λ²μ§Έμμ
βΆ ν΅κ³ν¨μ β 1. λͺ¨λ μ΄μ μ ν(*)β mysql> select * from circle;β β β 2. SELECTμ μ μμ μ§κΈκΉμ§ SELECTμ μ λλΆλΆμ μμ λ μ΄μ μ΄λ¦λ§μ μ§μ νμ§λ§ μμμλ 리ν°λ΄, κ³μ° λλ μ€μΉΌλΌ ν¨μλ₯Ό μ¬μ©ν μλ μλ€. β β μμ 10-1) 2019λ
μ λ±λ‘ν νμμ λν νλ², λ
λ, νκΈ°, μ₯νκΈμ‘, λ©λΆμ΄μ‘(λ±λ‘κΈ-μ₯νκΈ), λ©λΆκΈλΉμ¨(λ©λΆμ΄μ‘/λ±λ‘κΈ*100), '%'μ μΆλ ₯νμμ€. A) mysql> select stu_no, fee_year, fee_term, fee_total, jang_total, -> fee_pay "λ©λΆμ΄μ‘", fee_pay/fee_total*100 "λ©λΆκΈλΉμ¨", '%' -> from fee -> where fee_year = 2..
2021. 2. 8.
MySQL 15λ²μ§Έμμ
βΆ SELECT λͺ
λ Ήλ¬Έ μΌλΆ μ μ ν¬ν¨ν μν κ³Όμ β μμ 7-3) μκ°μ μ² ν
μ΄λΈ(attend)μμ 2006λ
λ 1νκΈ°μ μκ° μ μ²ν νμμ νλ²κ³Ό μκ°λ
λ, νκΈ°, κ΅κ³Όλͺ©μ½λ, κ΅μμ½λλ₯Ό κ΅μμ½λ μ€λ¦μ°¨μμΌλ‘ λνλ΄μ΄λΌ. β mysql> select stu_no, att_year, att_term, sub_code, prof_code → from attend → where att_year = '2016' and att_term = 1 → order by prof_code; β β 7-1) SELECT λͺ
λ Ήλ¬Έμλ 6κ°μ μ λ‘ κ΅¬μ±λμ΄ μλ€. 6κ° μ μ€μμ μλ΅μ΄ κ°λ₯ν μ μ 무μμΈκ° ? A) group by, having, where, order by μ . selectμ κ³Ό fromμ μ΄μΈλ μλ΅ κ°..
2021. 2. 8.
