πŸ–¨ SQL 문법 정리

κΉ€μ§€ν˜œΒ·2023λ…„ 5μ›” 4일
sql

SQL

λͺ©λ‘ 보기
1/5

select * from

select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from

from ~

select와 이미 λ§Œλ“  ν…Œμ΄λΈ”μ„ join μ‹œ ν™œμš©

EX.

select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
            inner join (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
group by (ν•„λ“œλͺ…)
) a on (ν•„λ“œλͺ…) = (ν•„λ“œλͺ…)

where

λ°μ΄ν„°μ˜ 절과 집합에 ν¬ν•¨λ˜κΈ° μœ„ν•΄ μΆ©μ‘±λ˜μ–΄μ•Ό ν•˜λŠ” ν•˜λ‚˜ μ΄μƒμ˜ 쑰건을 지정

inner join

두 ν…Œμ΄λΈ” μ—°κ²° μ‹œ μ‚¬μš©

EX.

select (A), (B), (subquery) from (A)
            inner join (B) on a(A) = a(B)

with

κΉ”λ”ν•˜κ²Œ 쿼리문 정리

EX.

select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
            inner join (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
group by (ν•„λ“œλͺ…)
) a on (ν•„λ“œλͺ…) = (ν•„λ“œλͺ…)

=>

with (table1) as (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
            inner join (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
group by (ν•„λ“œλͺ…)
), (table2) as (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
            inner join (
select (ν•„λ“œλͺ…), (ν•„λ“œλͺ…), (subquery) from (ν•„λ“œλͺ…)
group by (ν•„λ“œλͺ…)
)
profile
κΉ€μ§€ν˜œ
λ‹€μŒ 포슀트

mySQL 쑰회

0개의 λŒ“κΈ€