troubleshooting Question

Oracle query using DISTINCT

Avatar of Allen Pitts
Allen PittsFlag for United States of America asked on
Oracle DatabaseMicrosoft Access
4 Comments1 Solution104 ViewsLast Modified:
Hello expert,

Using the query copied herewith below yields 4758 rows

Running a similar query with
Select DISITNCT  PAYER_ID  
FROM CCM.CCM_COMPONENT_PRICING
  where last_update_user = 1

yields 202 rows.

The 202 rows is needed but with the other fields
resultant  from the longer query.

Tried creating a join with short table against the long table
and tried listing all 202 PAYER_IDs in an 'IN' statement
but both grab all of the PAYER IDs

Is there someway to mimic the return of the DISTINCT
query but return the other fields also?

Thanks

Allen in Dallas


++++++++++++++++LONG QUERY++++++++++++++
Select
COMPONENT_PRICING_ID,
  COMPONENT_ID,
  PAYER_ID,
  VARY_BY_MARKET,
  COMPONENT_PRICE,
  IS_OVERRIDE,
  CREATION_USER,
  CREATION_DATE,
  LAST_UPDATE_USER,
  LAST_UPDATE_DATE
  from
  CCM.CCM_COMPONENT_PRICING
  where last_update_user = 1
ASKER CERTIFIED SOLUTION
Log in to continue reading
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform for $9.99/mo
View membership options
Unlock 1 Answer and 4 Comments.
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
The Value of Experts Exchange in My Daily IT Life

Experts Exchange (EE) has become my company's go-to resource to get answers. I've used EE to make decisions, solve problems and even save customers. OutagesIO has been a challenging project and... Keep reading >>

Mike

Owner of Outages.IO
Phoenix, Arizona, United States
Member Since 2016
Join a full scale community that combines the best parts of other tools into one platform.
Unlock 1 Answer and 4 Comments.
View membership options
“All of life is about relationships, and EE has made a virtual community a real community. It lifts everyone's boat.”
William Peck

Member since 2004