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 | 1425 |
| 450 | REPORT z04_03. | sapjoy | 2012.07.31 | 1507 |
| 449 | REPORT z04_02. | sapjoy | 2012.07.31 | 1457 |
| 448 | REPORT z04_01. | sapjoy | 2012.07.31 | 1647 |
| 447 | REPORT z03_26. | sapjoy | 2012.07.31 | 1449 |
| 446 | REPORT z03_25. | sapjoy | 2012.07.31 | 1381 |
| 445 | REPORT z03_24 [1] | sapjoy | 2012.07.31 | 1509 |
| 444 | REPORT z03_23. | sapjoy | 2012.07.31 | 1587 |
| 443 | REPORT z03_22. | sapjoy | 2012.07.31 | 1553 |
| 442 | REPORT z03_21. | sapjoy | 2012.07.31 | 1534 |
| 441 | REPORT z03_20. | sapjoy | 2012.07.31 | 1625 |
| 440 | REPORT Z03_19. | sapjoy | 2012.07.31 | 1529 |
| 439 | REPORT Z03_18. | sapjoy | 2012.07.31 | 1505 |
| 438 | REPORT Z03_17. | sapjoy | 2012.07.31 | 1505 |
| 437 | REPORT z03_16. | sapjoy | 2012.07.31 | 1553 |
| 436 | REPORT z03_15. | sapjoy | 2012.07.31 | 1628 |
| 435 | REPORT Z03_14. | sapjoy | 2012.07.31 | 1579 |
| 434 | REPORT z03_13. | sapjoy | 2012.07.31 | 1647 |
| » | REPORT Z03_12. | sapjoy | 2012.07.31 | 1506 |
| 432 | REPORT z03_11. | sapjoy | 2012.07.31 | 1510 |
