|
Replies:
1
-
Pages:
1
-
Last Post:
Jul 27, 2010 8:38 AM
by: christopher.try...
|
Threads:
[
Previous
|
Next
]
|
|
|
|
|
|
SQL question
Posted:
Jul 27, 2010 8:15 AM
|
|
|
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
|
|
|
Posts:
18
Registered:
10/23/07
|
|
|
|
RE: [toad] SQL question
Posted:
Jul 27, 2010 8:38 AM
in response to: Bella Bechutsky
|
|
|
Google sqlplus specifically the break command.
chris
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
