Obsidian/Recognition/Work Related/프로젝트/스마트계류장/1.데이터베이스/실 데이터 검증.md

13 lines
242 B
Markdown

```sql
-- cargo 34번 활주로 사용 하는지 확인
select *
from (
select IATA_FLT, min(stand) as stand, min(RWY_NO ) as RWY_NO
from ucm.V_ANALS_ARR
where exp_dt like '2023-03-20%'
group by IATA_FLT ) A
where a.stand like '6__'
```