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 | 1445 |
| 450 | REPORT z04_03. | sapjoy | 2012.07.31 | 1538 |
| 449 | REPORT z04_02. | sapjoy | 2012.07.31 | 1490 |
| 448 | REPORT z04_01. | sapjoy | 2012.07.31 | 1690 |
| 447 | REPORT z03_26. | sapjoy | 2012.07.31 | 1485 |
| 446 | REPORT z03_25. | sapjoy | 2012.07.31 | 1405 |
| 445 | REPORT z03_24 [1] | sapjoy | 2012.07.31 | 1546 |
| 444 | REPORT z03_23. | sapjoy | 2012.07.31 | 1626 |
| 443 | REPORT z03_22. | sapjoy | 2012.07.31 | 1596 |
| 442 | REPORT z03_21. | sapjoy | 2012.07.31 | 1571 |
| 441 | REPORT z03_20. | sapjoy | 2012.07.31 | 1660 |
| 440 | REPORT Z03_19. | sapjoy | 2012.07.31 | 1559 |
| 439 | REPORT Z03_18. | sapjoy | 2012.07.31 | 1544 |
| 438 | REPORT Z03_17. | sapjoy | 2012.07.31 | 1541 |
| 437 | REPORT z03_16. | sapjoy | 2012.07.31 | 1594 |
| 436 | REPORT z03_15. | sapjoy | 2012.07.31 | 1661 |
| 435 | REPORT Z03_14. | sapjoy | 2012.07.31 | 1614 |
| 434 | REPORT z03_13. | sapjoy | 2012.07.31 | 1679 |
| » | REPORT Z03_12. | sapjoy | 2012.07.31 | 1535 |
| 432 | REPORT z03_11. | sapjoy | 2012.07.31 | 1543 |
