13 lines
242 B
Markdown
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__'
|
||
|
|
|
||
|
|
|
||
|
|
```
|