SQL to remove NULL and return 1 record

Hi,
I’ve a data situation where there is a need to suppress 2 rows into 1. Duplicate rows are due to the way data is stored in 2 separate records for 1 PM code.  Here is an example:
SELECT /*+ FIRST_ROWS(50) */ pmcode
        ,Estimated_Time
       ,Date_reviewed
       ,ORGANIZATION
       ,ppm_class
FROM   cmbc_pmschd_view;

Returns:
PMCODE          ESTIMATED _TIME   DATE_REVIEWED      ORGANIZATION   PPM_CLASS
1234            NULL                  4/17/2014                           ABC                  F123
1234            A                            NULL                                   ABC                  F123

I would like to see is:

PMCODE          ESTIMATED _TIME   DATE_REVIEWED      ORGANIZATION   PPM_CLASS
1234            A                  4/17/2014              ABC                  F123
LVL 11
mohammadzahidAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
MAX should do it.

select
PMCODE, max(ESTIMATED _TIME), max(DATE_REVIEWED), ORGANIZATION, PPM_CLASS
from cmbc_pmschd_view
group by PMCODE, ORGANIZATION, PPM_CLASS
/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.