SQL question

[Guest]

Please help me with the following.

Example

SELECT DISTINCT fund_code, org_code
FROM whatever_table;

How to change select to get like this (suppress repeated fund_codes).

Thank you,

Bella

fund_code org_code

01 100
200
300

02 150
250

03 610
620

[christopher.tryonhat]

Google sqlplus specifically the break command.

chris