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
| 번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
|---|---|---|---|---|
| 449 | REPORT z04_02. | sapjoy | 2012.07.30 | 1442 |
| 448 | REPORT z04_01. | sapjoy | 2012.07.30 | 1534 |
| 447 | REPORT z03_26. | sapjoy | 2012.07.30 | 1445 |
| 446 | REPORT z03_25. | sapjoy | 2012.07.30 | 1367 |
| 445 | REPORT z03_24 [1] | sapjoy | 2012.07.30 | 1428 |
| 444 | REPORT z03_23. | sapjoy | 2012.07.30 | 1575 |
| 443 | REPORT z03_22. | sapjoy | 2012.07.30 | 1541 |
| 442 | REPORT z03_21. | sapjoy | 2012.07.30 | 1522 |
| 441 | REPORT z03_20. | sapjoy | 2012.07.30 | 1615 |
| 440 | REPORT Z03_19. | sapjoy | 2012.07.30 | 1515 |
| 439 | REPORT Z03_18. | sapjoy | 2012.07.30 | 1495 |
| 438 | REPORT Z03_17. | sapjoy | 2012.07.30 | 1495 |
| 437 | REPORT z03_16. | sapjoy | 2012.07.30 | 1537 |
| 436 | REPORT z03_15. | sapjoy | 2012.07.30 | 1620 |
| 435 | REPORT Z03_14. | sapjoy | 2012.07.30 | 1568 |
| 434 | REPORT z03_13. | sapjoy | 2012.07.30 | 1632 |
| » | REPORT Z03_12. | sapjoy | 2012.07.30 | 1498 |
| 432 | REPORT z03_11. | sapjoy | 2012.07.30 | 1500 |
| 431 | REPORT z03_10. | sapjoy | 2012.07.30 | 1642 |
| 430 | REPORT z03_09. | sapjoy | 2012.07.30 | 1557 |
