REPORT Z03_12.
DATA: gv_carrid TYPE sflight-carrid,
gv_connid TYPE sflight-connid,
gv_paymentsum TYPE i.
SELECT carrid connid AVG( paymentsum ) as paymentsum
INTO (gv_carrid, gv_connid, gv_paymentsum)
FROM sflight
GROUP BY carrid connid
ORDER BY paymentsum.
WRITE: / gv_carrid, gv_connid, gv_paymentsum.
ENDSELECT.
DATA: gv_carrid TYPE sflight-carrid,
gv_connid TYPE sflight-connid,
gv_paymentsum TYPE i.
SELECT carrid connid AVG( paymentsum ) as paymentsum
INTO (gv_carrid, gv_connid, gv_paymentsum)
FROM sflight
GROUP BY carrid connid
ORDER BY paymentsum.
WRITE: / gv_carrid, gv_connid, gv_paymentsum.
ENDSELECT.
댓글 0
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 451 | REPORT z04_04. | sapjoy | 2012.07.31 | 1415 |
| 450 | REPORT z04_03. | sapjoy | 2012.07.31 | 1498 |
| 449 | REPORT z04_02. | sapjoy | 2012.07.31 | 1446 |
| 448 | REPORT z04_01. | sapjoy | 2012.07.31 | 1543 |
| 447 | REPORT z03_26. | sapjoy | 2012.07.31 | 1447 |
| 446 | REPORT z03_25. | sapjoy | 2012.07.31 | 1373 |
| 445 | REPORT z03_24 [1] | sapjoy | 2012.07.31 | 1501 |
| 444 | REPORT z03_23. | sapjoy | 2012.07.31 | 1583 |
| 443 | REPORT z03_22. | sapjoy | 2012.07.31 | 1547 |
| 442 | REPORT z03_21. | sapjoy | 2012.07.31 | 1527 |
| 441 | REPORT z03_20. | sapjoy | 2012.07.31 | 1621 |
| 440 | REPORT Z03_19. | sapjoy | 2012.07.31 | 1521 |
| 439 | REPORT Z03_18. | sapjoy | 2012.07.31 | 1503 |
| 438 | REPORT Z03_17. | sapjoy | 2012.07.31 | 1501 |
| 437 | REPORT z03_16. | sapjoy | 2012.07.31 | 1548 |
| 436 | REPORT z03_15. | sapjoy | 2012.07.31 | 1624 |
| 435 | REPORT Z03_14. | sapjoy | 2012.07.31 | 1575 |
| 434 | REPORT z03_13. | sapjoy | 2012.07.31 | 1644 |
| » | REPORT Z03_12. | sapjoy | 2012.07.31 | 1502 |
| 432 | REPORT z03_11. | sapjoy | 2012.07.31 | 1504 |
