Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TABLES : zpat_student.
- data : max_score type zpat_student-score,
- names type zpat_student-name,
- min_score type zpat_student-score.
- *--------------find max,min score-------------------------
- select max( score ) min( score ) into (max_score, min_score)
- from zpat_student.
- *-------------find name matching with score---------------
- SELECT * from zpat_student where score = max_score or score = min_score.
- write : / zpat_student-name, zpat_student-score.
- ENDSELECT.
Advertisement
Add Comment
Please, Sign In to add comment