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.30 | 1413 |
| 450 | REPORT z04_03. | sapjoy | 2012.07.30 | 1494 |
| 449 | REPORT z04_02. | sapjoy | 2012.07.30 | 1444 |
| 448 | REPORT z04_01. | sapjoy | 2012.07.30 | 1535 |
| 447 | REPORT z03_26. | sapjoy | 2012.07.30 | 1446 |
| 446 | REPORT z03_25. | sapjoy | 2012.07.30 | 1370 |
| 445 | REPORT z03_24 [1] | sapjoy | 2012.07.30 | 1492 |
| 444 | REPORT z03_23. | sapjoy | 2012.07.30 | 1577 |
| 443 | REPORT z03_22. | sapjoy | 2012.07.30 | 1544 |
| 442 | REPORT z03_21. | sapjoy | 2012.07.30 | 1524 |
| 441 | REPORT z03_20. | sapjoy | 2012.07.30 | 1617 |
| 440 | REPORT Z03_19. | sapjoy | 2012.07.30 | 1516 |
| 439 | REPORT Z03_18. | sapjoy | 2012.07.30 | 1497 |
| 438 | REPORT Z03_17. | sapjoy | 2012.07.30 | 1497 |
| 437 | REPORT z03_16. | sapjoy | 2012.07.30 | 1540 |
| 436 | REPORT z03_15. | sapjoy | 2012.07.30 | 1621 |
| 435 | REPORT Z03_14. | sapjoy | 2012.07.30 | 1572 |
| 434 | REPORT z03_13. | sapjoy | 2012.07.30 | 1636 |
| » | REPORT Z03_12. | sapjoy | 2012.07.30 | 1498 |
| 432 | REPORT z03_11. | sapjoy | 2012.07.30 | 1501 |
