REPORT Z04_007 .
DATA: carrid TYPE sflight-carrid,
avg_price TYPE p decimals 2.
SELECT carrid avg( price )
INTO (carrid, avg_price) FROM
sflight GROUP BY carrid.
WRITE: / carrid, avg_price.
ENDSELECT.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
» | REPORT Z04_007 [1] | sapjoy | 2008.04.15 | 2140 |
150 | REPORT z04_014 | sapjoy | 2007.05.22 | 2218 |
149 | REPORT Z04_013 | sapjoy | 2008.04.15 | 2304 |
148 | REPORT Z04_030 [1] | sapjoy | 2008.04.15 | 2268 |
147 | REPORT Z04_004 [7] | sapjoy | 2008.04.15 | 2487 |
146 | REPORT Z04_008 [1] | sapjoy | 2007.05.17 | 2150 |
145 | REPORT Z04_022 | sapjoy | 2007.05.17 | 2092 |
144 | REPORT Z04_021 [4] | sapjoy | 2007.05.17 | 2206 |
143 | REPORT Z04_002 | sapjoy | 2008.04.15 | 2447 |
142 | REPORT Z04_001 | sapjoy | 2007.05.16 | 2375 |
141 | REPORT Z03_030 | sapjoy | 2007.05.16 | 2166 |
140 | REPORT z03_029 [1] | sapjoy | 2007.05.16 | 2132 |
139 | REPORT Z03_028 | sapjoy | 2007.05.16 | 2102 |
138 | REPORT z03_022 [2] | sapjoy | 2007.05.15 | 2111 |
137 | REPORT Z03_017 [5] | sapjoy | 2008.04.15 | 2269 |
136 | REPORT Z03_019 [4] | sapjoy | 2008.04.15 | 2148 |
135 | REPORT Z03_018 [3] | sapjoy | 2006.12.03 | 2607 |
134 | REPORT Z03_016 [1] | sapjoy | 2007.05.15 | 2220 |
133 | REPORT Z03_015 | sapjoy | 2007.05.15 | 2131 |
132 | REPORT Z03_013 [4] | sapjoy | 2007.05.15 | 2388 |
왜 여기 복사하면 나오는데 제가 타이핑하면 안나올까요.. ㅠㅠ