troubleshooting Question

SQL only use record with higher value

Avatar of Michael Graham
Michael GrahamFlag for United States of America asked on
Microsoft SQL Server
7 Comments1 Solution52 ViewsLast Modified:

I am using SQL to create a query which is basically a big case when statement involving a lot of codes.  However, there can be two records for some of the people in the database.

For Example:

Name |Revenue|
John | $100|
Mike | $200|
Bob | $50|
Bob | $300|

In the above example "Bob" appears twice.  In these cases I only want to use the record where the Revenue is highest.  So in this case I only want to use the record where the Revenue is $300.  

Most of our records only have 1 name so most of the time there is just "John" or "Mike"

Is there a way to do this in SQL?

Thanks for any help,

Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros