troubleshooting Question

Query Help

Avatar of nmarano
nmarano asked on
Microsoft SQL Server 2008
2 Comments2 Solutions366 ViewsLast Modified:
Experts-

I'm looking for some help with a query that I have.  I am looking to return the newest record based on the date.  Here is what I have, but it is returning all records rather than just the record with the newest date.  Any help would be appreciated

-Nick

select distinct clients.productid AS productID, client_price.price as price,MAX(client_price.dateStart)
            from clients
            left join client_price on client_price.clientid = clients.id
        where client_price.opportunityID = 0
        and clients.productID = 3
        group by clients.productid,client_price.price
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 2 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 2 Answers and 2 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