REPORT Z04_009.
DATA wa TYPE sflight.
SELECT carrid connid
INTO (wa-carrid, wa-connid)
FROM sflight
WHERE carrid = 'AA'
GROUP BY carrid connid
HAVING
SUM( seatsocc ) > 500.
WRITE: / wa-carrid, wa-connid.
ENDSELECT.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
171 | REPORT Z02_014 | sapjoy | 2008.04.15 | 2112 |
170 | REPORT Z05_014 | sapjoy | 2008.04.15 | 3011 |
169 | REPORT z05_028 | sapjoy | 2007.05.30 | 2276 |
168 | REPORT Z05_026 [2] | sapjoy | 2007.05.28 | 2428 |
167 | REPORT Z05_012 [1] | sapjoy | 2008.04.15 | 2455 |
166 | REPORT Z05_010 [1] | sapjoy | 2007.05.28 | 2122 |
165 | REPORT Z05_009 [2] | sapjoy | 2007.05.28 | 2150 |
164 | REPORT Z05_008 [2] | sapjoy | 2007.05.28 | 2612 |
163 | REPORT Z05_007 [2] | sapjoy | 2007.05.27 | 2192 |
162 | REPORT z05_005 | sapjoy | 2007.05.22 | 2160 |
161 | REPORT Z05_004 | sapjoy | 2008.04.15 | 2227 |
160 | REPORT Z04_033 [1] | sapjoy | 2008.04.15 | 2456 |
159 | REPORT Z04_019 [2] | sapjoy | 2007.05.22 | 2476 |
158 | REPORT Z04_018 | sapjoy | 2007.05.22 | 2110 |
157 | REPORT Z04_017 | sapjoy | 2007.05.22 | 2233 |
156 | REPORT Z04_015 | sapjoy | 2007.05.17 | 2111 |
155 | REPORT Z04_012 [1] | sapjoy | 2007.05.17 | 2064 |
154 | REPORT Z04_011 [1] | sapjoy | 2007.05.17 | 2249 |
153 | REPORT Z04_010 | sapjoy | 2008.04.15 | 2153 |
» | REPORT z04_009 [1] | sapjoy | 2007.09.13 | 2202 |